Re: benchmark results comparing versions 15.2 and 16

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: benchmark results comparing versions 15.2 and 16
Дата
Msg-id ZGQs8Ipaec0x+5yR@paquier.xyz
обсуждение исходный текст
Ответ на Re: benchmark results comparing versions 15.2 and 16  (Alexander Lakhin <exclusion@gmail.com>)
Ответы Re: benchmark results comparing versions 15.2 and 16  (Alexander Lakhin <exclusion@gmail.com>)
Список pgsql-hackers
On Tue, May 16, 2023 at 06:00:00PM +0300, Alexander Lakhin wrote:
> I can confirm that the patches improve (restore) performance for my test:
> pgbench -i benchdb
> pgbench -c 10 -T 300 benchdb

Thanks for running these!

> tps (over three runs):
> HEAD (08c45ae23):
> 10238.441580, 10697.202119, 10706.764703
>
> HEAD with the patches:
> 11134.510118, 11176.554996, 11150.338488
>
> f193883fc~1 (240e0dbac)
> 11082.561388, 11233.604446, 11087.071768
>
> 15.3 (8382864eb)
> 11328.699555, 11128.057883, 11057.934392

The numbers between f193883fc~1 and HEAD+patch are close to each
other.  It does not seem to make the whole difference with 15.3, but
most of it.  The difference can also be explained with some noise,
based on the number patterns of the third runs?

I have now applied the revert, ready for beta1.  Thanks for the
feedback!
--
Michael

Вложения

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

Предыдущее
От: Peter Smith
Дата:
Сообщение: Re: [DOC] Update ALTER SUBSCRIPTION documentation v3
Следующее
От: "Zhijie Hou (Fujitsu)"
Дата:
Сообщение: Reload configuration more frequently in apply worker.