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

From Alexander Lakhin
Subject Re: benchmark results comparing versions 15.2 and 16
Date
Msg-id 62b9850a-4c95-26c2-0aeb-d1d00434a13b@gmail.com
Whole thread Raw
In response to Re: benchmark results comparing versions 15.2 and 16  (Michael Paquier <michael@paquier.xyz>)
Responses Re: benchmark results comparing versions 15.2 and 16
List 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



pgsql-hackers by date:

Previous
From: "Jonathan S. Katz"
Date:
Subject: Re: WL_SOCKET_ACCEPT fairness on Windows
Next
From: Kirk Wolak
Date:
Subject: Re: Adding SHOW CREATE TABLE