Re: benchmark results comparing versions 15.2 and 16 - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: benchmark results comparing versions 15.2 and 16
Date
Msg-id ZGQs8Ipaec0x+5yR@paquier.xyz
Whole thread Raw
In response to Re: benchmark results comparing versions 15.2 and 16  (Alexander Lakhin <exclusion@gmail.com>)
Responses Re: benchmark results comparing versions 15.2 and 16
List 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

Attachment

pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Re: [DOC] Update ALTER SUBSCRIPTION documentation v3
Next
From: "Zhijie Hou (Fujitsu)"
Date:
Subject: Reload configuration more frequently in apply worker.