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

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Uh, I change my mind about commit_delay + commit_siblings (sort of)
Дата
Msg-id 4FC469D5.7020209@enterprisedb.com
обсуждение исходный текст
Ответ на Uh, I change my mind about commit_delay + commit_siblings (sort of)  (Peter Geoghegan <peter@2ndquadrant.com>)
Ответы Re: Uh, I change my mind about commit_delay + commit_siblings (sort of)  (Peter Geoghegan <peter@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Alex
Дата:
Сообщение: Re: libpq URL syntax vs SQLAlchemy
Следующее
От: Marti Raudsepp
Дата:
Сообщение: Re: Bogus nestloop rows estimate in 8.4.7