Re: Query performance in 9.6.24 vs 14.10

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Query performance in 9.6.24 vs 14.10
Date: 2024-01-29 03:44:04
Message-ID: CAApHDvoLBOuoWyqPunAuOONCuvP2TuOpDvR8TACYCq6ZJiLmWQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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...?

David

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2024-01-29 07:55:16 Re: Query performance in 9.6.24 vs 14.10
Previous Message Ron Johnson 2024-01-28 18:36:58 Query performance in 9.6.24 vs 14.10