Re: benchmark results comparing versions 15.2 and 16
Michael Paquier <michael@paquier.xyz>
From: Michael Paquier <michael@paquier.xyz>
To: Alexander Lakhin <exclusion@gmail.com>
Cc: Andres Freund <andres@anarazel.de>, MARK CALLAGHAN <mdcallag@gmail.com>, pgsql-hackers@lists.postgresql.org
Date: 2023-05-17T01:25:04Z
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
Commits
-
Add back SQLValueFunction for SQL keywords
- d8c3106bb60e 16.0 landed
-
Add missing TAP test name
- 1ab763fc22ad 16.0 cited
-
Have the planner consider Incremental Sort for DISTINCT
- 3c6fc58209f2 16.0 cited