| From: | Alexander Lakhin <exclusion(at)gmail(dot)com> |
|---|---|
| To: | Michael Paquier <michael(at)paquier(dot)xyz>, Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | 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-16 15:00:00 |
| Message-ID: | 62b9850a-4c95-26c2-0aeb-d1d00434a13b@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
15.05.2023 08:20, Michael Paquier wrote:
> I am not going to let that hang in the air with beta1 getting released
> next week, though, so attached are two patches to revert the change
> (these would be combined, just posted this way for clarity).
I can confirm that the patches improve (restore) performance for my test:
pgbench -i benchdb
pgbench -c 10 -T 300 benchdb
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
Best regards,
Alexander
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kirk Wolak | 2023-05-16 15:33:47 | Re: Adding SHOW CREATE TABLE |
| Previous Message | Jonathan S. Katz | 2023-05-16 14:57:09 | Re: WL_SOCKET_ACCEPT fairness on Windows |