Re: pgsql: Change floating-point output format for improved performance.

2019-02-13 Thread Andrew Gierth
> "Andrew" == Andrew Dunstan writes: >>> Cross-version upgrade is the big problem; I have no real idea how to >>> make that test work short of adding another GUC; revert? >> Andrew Dunstan might be able to help, although I'm not immediately >> sure how... Andrew> Me either. I can, of c

Re: pgsql: Change floating-point output format for improved performance.

2019-02-13 Thread Andrew Dunstan
On 2/13/19 12:01 PM, Andres Freund wrote: > Hi Andrew^2, > > On 2019-02-13 16:38:16 +, Andrew Gierth wrote: >> Cross-version upgrade is the big problem; I have no real idea how to >> make that test work short of adding another GUC; revert? > Andrew Dunstan might be able to help, although I'm

Re: pgsql: Change floating-point output format for improved performance.

2019-02-13 Thread Andres Freund
Hi Andrew^2, On 2019-02-13 16:38:16 +, Andrew Gierth wrote: > Cross-version upgrade is the big problem; I have no real idea how to > make that test work short of adding another GUC; revert? Andrew Dunstan might be able to help, although I'm not immediately sure how... Greetings, Andres Freu

Re: pgsql: Change floating-point output format for improved performance.

2019-02-13 Thread Andrew Gierth
> "Andrew" == Andrew Gierth writes: Fallout so far: Cygwin claims to have strtof, but it silently underflows to zero and misrounds input. Could be fixable with a variant output file? ICC seems to be miscompiling something, that'll need investigation. s390 failures: ts_rank isn't as numeric

Re: pgsql: Change floating-point output format for improved performance.

2019-02-13 Thread Andrew Gierth
Already aware of the windows breakage, will fix in a sec. -- Andrew (irc:RhodiumToad)

pgsql: Change floating-point output format for improved performance.

2019-02-13 Thread Andrew Gierth
Change floating-point output format for improved performance. Previously, floating-point output was done by rounding to a specific decimal precision; by default, to 6 or 15 decimal digits (losing information) or as requested using extra_float_digits. Drivers that wanted exact float values, and app