Re: PG 12 draft release notes

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
Cc: Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PG 12 draft release notes
Date: 2019-05-21 20:28:02
Message-ID: 20190521202801.2priab2ojs65yibh@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, May 21, 2019 at 12:08:25AM +0100, Andrew Gierth wrote:
> >>>>> "Andres" == Andres Freund <andres(at)anarazel(dot)de> writes:
>
> Andres> Any chance for you to propose a text?
>
> This is what I posted before; I'm not 100% happy with it but it's still
> better than any of the other versions:
>
> * Output REAL and DOUBLE PRECISION values in shortest-exact format by
> default, and change the behavior of extra_float_digits
>
> Previously, float values were output rounded to 6 or 15 decimals by
> default, with the number of decimals adjusted by extra_float_digits.
> The previous rounding behavior is no longer the default, and is now
> done only if extra_float_digits is set to zero or less; if the value
> is greater than zero (which it is by default), a shortest-precise
> representation is output (for a substantial performance improvement).
> This representation preserves the exact binary value when correctly
> read back in, even though the trailing digits will usually differ
> from the output generated by previous versions when
> extra_float_digits=3.

How is this?

<para>
Improve performance by changing the default number of trailing digits
output for <link linkend="datatype-float"><type>REAL</type></link>
and <type>DOUBLE PRECISION</type> values (Andrew Gierth)
</para>

<para>
Previously, float values were output rounded to 6 or 15 decimals
by default. Now, only the number of digits required to preserve
the exact binary value is output. The previous behavior can be
restored by setting <xref linkend="guc-extra-float-digits"> to zero.
</para>

Am I missing something?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2019-05-21 20:35:48 Re: PG 12 draft release notes
Previous Message Robert Haas 2019-05-21 20:13:12 Re: POC: Cleaning up orphaned files using undo logs