pgsql: Don't wait for the commit record to be replicated if we wrote no

From: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Don't wait for the commit record to be replicated if we wrote no
Date: 2012-04-17 13:37:14
Message-ID: E1SK8ao-000455-IG@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Don't wait for the commit record to be replicated if we wrote no WAL.

When using synchronous replication, we waited for the commit record to be
replicated, but if we our transaction didn't write any other WAL records,
that's not required because we don't even flush the WAL locally to disk in
that case. This lead to long waits when committing a transaction that only
modified a temporary table. Bug spotted by Thom Brown.

Branch
------
REL9_1_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/10fcfada235af6186c9474230483ab0fe5c9610d

Modified Files
--------------
src/backend/access/transam/xact.c | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Fujii Masao 2012-04-17 19:29:12 Re: [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.
Previous Message Heikki Linnakangas 2012-04-17 13:34:42 pgsql: Don't wait for the commit record to be replicated if we wrote no