On Thu, 2010-12-30 at 22:11 +0200, Marti Raudsepp wrote:
> I think a comment about the "head-of-line blocking" nature of
> streaming repliaction is in order. If you execute massive writes in
> async mode and then run a transaction in sync mode, its commit will be
> delayed until all the async transactions before it have been applied
> on the slave.
Not really sure I understand what you want me to add there. The case you
mention is identical whether we use the word "async" or "sync" where you
mention "in async mode".
Replication doesn't wait until a sync commit is requested, it is
continuously active.
Sync rep's only addition are the reply messages.
-- Simon Riggs http://www.2ndQuadrant.com/books/PostgreSQL Development, 24x7 Support, Training and Services