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.
src/backend/access/transam/xact.c | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
pgsql-committers by date
|Next:||From: Heikki Linnakangas||Date: 2012-04-17 13:37:14|
|Subject: pgsql: Don't wait for the commit record to be replicated if we wroteno|
|Previous:||From: Thom Brown||Date: 2012-04-17 12:52:00|
|Subject: Re: [COMMITTERS] pgsql: Add new replication mode
synchronous_commit = 'write'.|