Horton

Re: Uh, I change my mind about commit_delay + commit_siblings (sort of)

Peter Geoghegan <peter@2ndquadrant.com>

View thread
From: Peter Geoghegan <peter@2ndquadrant.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Simon Riggs <simon@2ndquadrant.com>, Robert Haas <robertmhaas@gmail.com>, PG Hackers <pgsql-hackers@postgresql.org>
Date: 2012-06-01T19:15:19Z
Lists: pgsql-hackers 
This is a benchmark I performed on the same hardware, for tpc-b.sql,
with a commit_delay of 0 and 4000 for the patch:

http://tpcbdelay.staticloud.com/

There is a rather large improvement in throughput here. Robert
previously complained that our group commit implementation didn't do
very well on that benchmark. This seems to make all the difference.

-- 
Peter Geoghegan       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services