Re: group commit

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: group commit
Date: 2014-06-04 19:37:18
Message-ID: 1401910638186-5806064.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Evgeniy Shishkin wrote
> Hi,
>
> i just wanted to know if group commit (as described in
> https://wiki.postgresql.org/wiki/Group_commit ) was committed.

I guess that depends on whether this comment in the 9.2 release notes covers
the same material described in the linked wiki page (I would presume it
does).

http://www.postgresql.org/docs/9.2/interactive/release-9-2.html
Section: E.9.3.1.1. Performance

> Allow group commit to work effectively under heavy load (Peter Geoghegan,
> Simon Riggs, Heikki Linnakangas)
>
> Previously, batching of commits became ineffective as the write workload
> increased, because of internal lock contention.

Though based upon your question regarding parallel replication I am thinking
that maybe your concept of "group commit" and the one that was implemented
are quite different...

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/group-commit-tp5806056p5806064.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Linos 2014-06-04 19:58:29 Re: Possible performance regression in PostgreSQL 9.2/9.3?
Previous Message Merlin Moncure 2014-06-04 19:36:45 Re: Possible performance regression in PostgreSQL 9.2/9.3?