pgsql: Avoid unnecessary acquisition of SyncRepLock in transaction comm

From: Fujii Masao <fujii(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Avoid unnecessary acquisition of SyncRepLock in transaction comm
Date: 2020-09-02 01:56:29
Message-ID: E1kDI0j-0003VF-1C@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Avoid unnecessary acquisition of SyncRepLock in transaction commit time.

In SyncRepWaitForLSN() routine called in transaction commit time,
SyncRepLock is necessary to atomically both check the shared
sync_standbys_defined flag and operate the sync replication wait-queue.
On the other hand, when the flag is false, the lock is not necessary
because the wait-queue is not touched. But due to the changes by
commit 48c9f49265, previously the lock was taken whatever the flag was.
This could cause unnecessary performance overhead in every transaction
commit time. Therefore this commit avoids that unnecessary aquisition
of SyncRepLock.

Author: Fujii Masao
Reviewed-by: Asim Praveen, Masahiko Sawada,
Discussion: https://postgr.es/m/20200406050332.nsscfqjzk2d57zyx@alap3.anarazel.de

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/be9788e9989a0744ba60ab100153340fd123b786

Modified Files
--------------
src/backend/replication/syncrep.c | 24 ++++++++++++++++++------
1 file changed, 18 insertions(+), 6 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2020-09-02 05:58:16 pgsql: Fix thinko with definition of REINDEXOPT_MISSING_OK
Previous Message Alvaro Herrera 2020-09-02 00:45:10 pgsql: Fix typo in comment