extra_float_digits
This parameter adjusts the number of digits displayed for floating-point values, including float4, float8, and geometric data types. The parameter value is added to the standard number of digits (FLT_DIG
or DBL_DIG
as appropriate). The value can be set as high as 3, to include partially-significant digits; this is especially useful for dumping float data that needs to be restored exactly. Or it can be set negative to suppress unwanted digits. See also datatype-float.
Recommendations
Only significant for applications which do a lot of float calculations, like scientific databases.
Comments
Type: | integer |
Default: | 0 |
Min: | -15 |
Max: | 3 |
Context: | user |
Restart: | false |
On StackOverflow
- SET extra_float_digits = 3 in postgresql
- pycharm and postgres: ERROR: Unsupported startup parameter: extra_float_digits
- PostgreSQL pg_stat_activity gets filled with "SET extra_float_digits = 3" query causing Error calling Driver#connect
- Postgres NetBeans connection driver issue
- How to avoid the idle connections in postgres 9.3