pgsql: Acquire ProcArrayLock exclusively in ProcArrayClearTransaction. - Mailing list pgsql-committers

From Andres Freund
Subject pgsql: Acquire ProcArrayLock exclusively in ProcArrayClearTransaction.
Date
Msg-id E1k8ZUj-00051o-7o@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Acquire ProcArrayLock exclusively in ProcArrayClearTransaction.

This corrects an oversight by me in 20729324078, which made
ProcArrayClearTransaction() increment xactCompletionCount. That requires an
exclusive lock, obviously.

There's other approaches that avoid the exclusive acquisition, but given that a
2PC commit is fairly heavyweight, it doesn't seem worth doing so. I've not been
able to measure a performance difference, unsurprisingly.  I did add a
comment documenting that we could do so, should it ever become a bottleneck.

Reported-By: Tom Lane <tgl@sss.pgh.pa.us>
Author: Andres Freund <andres@anarazel.de>
Discussion: https://postgr.es/m/1355915.1597794204@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/1fe1f42e3e85279e1cb8b004b3b076a04bde4cee

Modified Files
--------------
src/backend/storage/ipc/procarray.c | 19 +++++++++++++------
1 file changed, 13 insertions(+), 6 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Suppress unnecessary RelabelType nodes in yet more cases.
Next
From: Alvaro Herrera
Date:
Subject: pgsql: Revise REINDEX CONCURRENTLY recovery instructions