Pg 12 does fix the problem, and the numbers are slightly better than
that of Gnumeric and LibreOffice Calc.
2019/4/16 21:41, Jeff Janes:
> On Tue, Apr 16, 2019 at 3:55 AM PG Bug reporting form
> <noreply@postgresql.org <mailto:noreply@postgresql.org>> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference: 15758
> Logged by: Dingyuan Wang
> Email address: gumblex@aosc.io <mailto:gumblex@aosc.io>
> PostgreSQL version: 11.2
> Operating system: Debian
> Description:
>
> This can reproduce on at least version 10 or 11, on Debian amd64.
> Given the following data:
>
>
> This will be improved in version 12 when that is released later this
> year. See the below commit:
>
> commit e954a727f0c8872bf5203186ad0f5312f6183746
> Author: Dean Rasheed <dean.a.rasheed@gmail.com
> <mailto:dean.a.rasheed@gmail.com>>
> Date: Sat Oct 6 11:20:09 2018 +0100
>
> Improve the accuracy of floating point statistical aggregates.
>
>
>
> Cheers,
>
> Jeff