From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Query performance in 9.6.24 vs 14.10 |
Date: | 2024-01-29 07:55:16 |
Message-ID: | CANzqJaB5G2LNyuXQUVKzZFeTcOHM6Y8HMn0A6W9w8AM6R7LTYg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sun, Jan 28, 2024 at 10:44 PM David Rowley <dgrowleyml(at)gmail(dot)com> wrote:
> On Mon, 29 Jan 2024 at 07:37, Ron Johnson <ronljohnsonjr(at)gmail(dot)com> wrote:
>
>> 08 9.6.24 1,142.164 1,160.801 1,103.716 1,249.852 1,191.081
>> 14.10 159.354 155.111 155.111 162.797 158.157 86.72%
>>
>
> Your speedup per cent calculation undersells PG14 by quite a bit. I'd
> call that an increase of ~639% rather than 86.72%.
>
> I think you've done "1 - sum( <14.10 numbers> ) / sum( <9.6.24 numbers>)"
> whereas I think you should have done "sum( <9.6.24 numbers>) / sum( <14.10
> numbers> ) - 1"
>
> Nonetheless, thanks for testing this out. I assume this is just a report
> giving good feedback about progress in this area...?
>
The spreadsheet function, using the Median cells, is (PG9.6 - PG14) /
PG9.6). That's essentially the same as what you wrote.
158.157 / 1191.081 = 0.13278
1191.081 / 158.157 = 7.53, so 9.6.24 on that query is 7.53x slower.
From | Date | Subject | |
---|---|---|---|
Next Message | Laura Smith | 2024-01-29 08:12:17 | Scriptable way to validate a pg_dump restore ? |
Previous Message | David Rowley | 2024-01-29 03:44:04 | Re: Query performance in 9.6.24 vs 14.10 |