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

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Peter Geoghegan <peter(at)2ndquadrant(dot)com>
Cc: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Uh, I change my mind about commit_delay + commit_siblings (sort of)
Date: 2012-05-29 06:16:53
Message-ID: 4FC469D5.7020209@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marti Raudsepp 2012-05-29 08:06:19 Re: Bogus nestloop rows estimate in 8.4.7
Previous Message Hugo <Nabble> 2012-05-29 05:21:03 Re: pg_dump and thousands of schemas