pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
group commit
2+ messages / 2 participants
[nested] [flat]

* group commit
@ 2014-06-04 18:44  Evgeny Shishkin <itparanoia@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Evgeny Shishkin @ 2014-06-04 18:44 UTC (permalink / raw)
  To: pgsql-performance

Hi, 

i just wanted to know if group commit (as described in https://wiki.postgresql.org/wiki/Group_commit ) was committed.

And if parallel replication is going to be introduced. 
Mysql 5.7 going to have intra-database parallel slave based on group commit on master. 

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: group commit
@ 2014-06-04 19:37  David G Johnston <david.g.johnston@gmail.com>
  parent: Evgeny Shishkin <itparanoia@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: David G Johnston @ 2014-06-04 19:37 UTC (permalink / raw)
  To: 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.


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2014-06-04 19:37 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-06-04 18:44 group commit Evgeny Shishkin <itparanoia@gmail.com>
2014-06-04 19:37 ` David G Johnston <david.g.johnston@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox