Re: PG 12 draft release notes

Поиск
Список
Период
Сортировка
Искать
От
Andres Freund
Тема
Re: PG 12 draft release notes
Дата
в 23:16:22
Msg-id
20190520231622.luikygarhxss5luy@alap3.anarazel.de
Ответ на
Список
Дерево обсуждения
PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Andres Freund <andres@anarazel.de>
Re: PG 12 draft release notes Tom Lane <tgl@sss.pgh.pa.us>
Re: PG 12 draft release notes Andres Freund <andres@anarazel.de>
Re: PG 12 draft release notes Tom Lane <tgl@sss.pgh.pa.us>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Tom Lane <tgl@sss.pgh.pa.us>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Andres Freund <andres@anarazel.de>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: PG 12 draft release notes Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: PG 12 draft release notes Andres Freund <andres@anarazel.de>
Re: PG 12 draft release notes Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: PG 12 draft release notes Andres Freund <andres@anarazel.de>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Peter Geoghegan <pg@bowt.ie>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Peter Geoghegan <pg@bowt.ie>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Peter Geoghegan <pg@bowt.ie>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Peter Geoghegan <pg@bowt.ie>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Peter Geoghegan <pg@bowt.ie>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Peter Geoghegan <pg@bowt.ie>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Peter Geoghegan <pg@bowt.ie>
Re: PG 12 draft release notes Alexander Korotkov <aekorotkov@gmail.com>
Re: PG 12 draft release notes Haribabu Kommi <kommi.haribabu@gmail.com>
Re: PG 12 draft release notes David Rowley <david.rowley@2ndquadrant.com>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Shawn Debnath <sdn@amazon.com>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Andres Freund <andres@anarazel.de>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: PG 12 draft release notes Laurenz Albe <laurenz.albe@cybertec.at>
Re: PG 12 draft release notes Michael Paquier <michael@paquier.xyz>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes "Jonathan S. Katz" <jkatz@postgresql.org>
Re: PG 12 draft release notes Andrey Borodin <x4mmm@yandex-team.ru>
Re: PG 12 draft release notes "Jonathan S. Katz" <jkatz@postgresql.org>
Re: PG 12 draft release notes nickb <nickb@imap.cc>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes "Jonathan S. Katz" <jkatz@postgresql.org>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes "Jonathan S. Katz" <jkatz@postgresql.org>
Re: PG 12 draft release notes Adrien Nayrat <adrien.nayrat@anayrat.info>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Fabien COELHO <coelho@cri.ensmp.fr>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Oleg Bartunov <obartunov@postgrespro.ru>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Oleg Bartunov <obartunov@postgrespro.ru>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes David Rowley <david.rowley@2ndquadrant.com>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Ian Barwick <ian.barwick@2ndquadrant.com>
Re: PG 12 draft release notes Michael Paquier <michael@paquier.xyz>
Re: PG 12 draft release notes Ian Barwick <ian.barwick@2ndquadrant.com>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Michael Paquier <michael@paquier.xyz>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Re: PG 12 draft release notes Michael Paquier <michael@paquier.xyz>
Re: PG 12 draft release notes John Naylor <john.naylor@2ndquadrant.com>
Re: PG 12 draft release notes Bruce Momjian <bruce@momjian.us>
Hi,

On 2019-05-21 00:08:25 +0100, Andrew Gierth wrote:
> >>>>> "Andres" == Andres Freund  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.

Definitely better from what's there in my opinion. Shortening it if
reasonable wouldn't hurt. Perhaps

Output REAL and DOUBLE PRECISION values in shortest-exact format by
default, and change the behavior of extra_float_digits (...)

When extra_float_digits is set to a value greater than zero (the
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.

Previously, float values were output rounded to 6 or 15 decimals by
default, with the number of decimals adjusted by
extra_float_digits. This behaviour can be restored by setting
extra_float_digits is set to zero or less.

Or something in that vein?

Greetings,

Andres Freund


В списке pgsql-hackers по дате отправления
От: Andres Freund
Дата:
Сообщение: Re: PG 12 draft release notes
От: Thomas Munro
Дата:
FAQ