On Wed, Jun 24, 2020 at 9:51 PM David Rowley <dgrowle...@gmail.com> wrote: > $ pgbench -n -f pg-tpch/queries/q01.sql -T 120 tpch > > Which is about a 1.42% increase in performance. That's not exactly > groundbreaking, but pretty useful to have if that happens to apply > across the board for execution performance. > > For pgbench -S: > > My results were a bit noisier than the TPCH test, but the results I > obtained did show about a 10% increase in performance:
This is pretty cool, particularly because it affects single-client performance. It seems like a lot of ideas people have had about speeding up pgbench performance - including me - have improved performance under concurrency at the cost of very slightly degrading single-client performance. It would be nice to claw some of that back. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
