| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | Alexander Lakhin <exclusion(at)gmail(dot)com> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, MARK CALLAGHAN <mdcallag(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: benchmark results comparing versions 15.2 and 16 |
| Date: | 2023-05-17 01:25:04 |
| Message-ID: | ZGQs8Ipaec0x+5yR@paquier.xyz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zhijie Hou (Fujitsu) | 2023-05-17 01:47:51 | Reload configuration more frequently in apply worker. |
| Previous Message | Peter Smith | 2023-05-17 01:18:26 | Re: [DOC] Update ALTER SUBSCRIPTION documentation v3 |