pgsql: Fix calculation of PREDICATELOCK_MANAGER_LWLOCK_OFFSET. - Mailing list pgsql-committers

From Kevin Grittner
Subject pgsql: Fix calculation of PREDICATELOCK_MANAGER_LWLOCK_OFFSET.
Date
Msg-id E1Wxcow-00080z-Bz@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix calculation of PREDICATELOCK_MANAGER_LWLOCK_OFFSET.

Commit ea9df812d8502fff74e7bc37d61bdc7d66d77a7f failed to include
NUM_BUFFER_PARTITIONS in this offset, resulting in a bad offset.
Ultimately this threw off NUM_FIXED_LWLOCKS which is based on
earlier offsets, leading to memory allocation problems.  It seems
likely to have also caused increased LWLOCK contention when
serializable transactions were used, because lightweight locks used
for that overlapped others.

Reported by Amit Kapila with analysis and fix.
Backpatch to 9.4, where the bug was introduced.

Branch
------
REL9_4_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/909cab83058b12cabec6fb10c945f67ef09de5ec

Modified Files
--------------
src/include/storage/lwlock.h |    2 +-
1 file changed, 1 insertion(+), 1 deletion(-)


pgsql-committers by date:

Previous
From: Fujii Masao
Date:
Subject: pgsql: Don't allow data_directory to be set in postgresql.auto.conf by
Next
From: Kevin Grittner
Date:
Subject: pgsql: Fix calculation of PREDICATELOCK_MANAGER_LWLOCK_OFFSET.