readysettech / readyset

Readyset is a MySQL and Postgres wire-compatible caching layer that sits in front of existing databases to speed up queries and horizontally scale read throughput. Under the hood, ReadySet caches the results of cached select statements and incrementally updates these results over time as the underlying data changes.
https://readyset.io
Other
4.54k stars 125 forks source link

Expand acceptable values for `extra_float_digits` #1379

Closed jasobrown-rs closed 1 month ago

jasobrown-rs commented 1 month ago

Description

Readyset currently only accepts 1 as a value for the postgres session variable extra_float_digits; the range of acceptable values is -15..3. As PG 12, any value greater than zero is, more or less, the same (they all return "shortest-precise" output format). Therefore, we should acceptable any value greater than zero.

[0] https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-EXTRA-FLOAT-DIGITS

[1] https://www.postgresql.org/docs/current/datatype-numeric.html#DATATYPE-FLOAT