Re: Query performance in 9.6.24 vs 14.10

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Query performance in 9.6.24 vs 14.10
Дата
Msg-id CANzqJaB5G2LNyuXQUVKzZFeTcOHM6Y8HMn0A6W9w8AM6R7LTYg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Query performance in 9.6.24 vs 14.10  (David Rowley <dgrowleyml@gmail.com>)
Ответы Re: Query performance in 9.6.24 vs 14.10
Список pgsql-general
Дерево обсуждения
On Sun, Jan 28, 2024 at 10:44 PM David Rowley <dgrowleyml@gmail.com> wrote:
On Mon, 29 Jan 2024 at 07:37, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
089.6.241,142.1641,160.8011,103.7161,249.8521,191.081
14.10159.354155.111155.111162.797158.15786.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.

В списке pgsql-general по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: Query performance in 9.6.24 vs 14.10
Следующее
От: Laura Smith
Дата:
Сообщение: Scriptable way to validate a pg_dump restore ?