Re: Uh, I change my mind about commit_delay + commit_siblings (sort of) - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Uh, I change my mind about commit_delay + commit_siblings (sort of)
Date
Msg-id 4FC469D5.7020209@enterprisedb.com
Whole thread Raw
In response to Uh, I change my mind about commit_delay + commit_siblings (sort of)  (Peter Geoghegan <peter@2ndquadrant.com>)
Responses Re: Uh, I change my mind about commit_delay + commit_siblings (sort of)
List 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


pgsql-hackers by date:

Previous
From: Alex
Date:
Subject: Re: libpq URL syntax vs SQLAlchemy
Next
From: Marti Raudsepp
Date:
Subject: Re: Bogus nestloop rows estimate in 8.4.7