Horton

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

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

View thread
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Peter Geoghegan <peter@2ndquadrant.com>
Cc: PG Hackers <pgsql-hackers@postgresql.org>
Date: 2012-05-29T06:16:53Z
Lists: pgsql-hackers 
On 29.05.2012 04:18, Peter Geoghegan wrote:
> The attached very simple patch moves the commit_delay +
> commit_siblings sleep into XLogFlush, where the leader alone sleeps.
> This appears to be a much more effective site for a delay.
>
> Benchmark results, with and without a delay of 3000ms (commit_siblings
> is 0 in both cases) are available from:
>
> http://leadercommitdelay.staticloud.com

Can you elaborate how to read those results? What do "insert delay test" 
and "patch, commit_delay=0" mean? Which graph should I be looking at?

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com