pgsql: Allow page lock to conflict among parallel group members. - Mailing list pgsql-committers

From Amit Kapila
Subject pgsql: Allow page lock to conflict among parallel group members.
Date
Msg-id E1jFUmx-0004N0-Qe@gemulon.postgresql.org
Whole thread Raw
Responses Re: pgsql: Allow page lock to conflict among parallel group members.
List pgsql-committers
Allow page lock to conflict among parallel group members.

This is required as it is no safer for two related processes to perform
clean up in gin indexes at a time than for unrelated processes to do the
same.  After acquiring page locks, we can acquire relation extension lock
but reverse never happens which means these will also not participate in
deadlock.  So, avoid checking wait edges from this lock.

Currently, the parallel mode is strictly read-only, but after this patch
we have the infrastructure to allow parallel inserts and parallel copy.

Author: Dilip Kumar, Amit Kapila
Reviewed-by: Amit Kapila, Kuntal Ghosh and Sawada Masahiko
Discussion: https://postgr.es/m/CAD21AoCmT3cFQUN4aVvzy5chw7DuzXrJCbrjTU05B+Ss=Gn1LA@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/3ba59ccc896e8877e2fbfb8d4f148904cad5f9b0

Modified Files
--------------
src/backend/optimizer/plan/planner.c | 13 +++-----
src/backend/storage/lmgr/README      | 60 ++++++++++++++++++++----------------
src/backend/storage/lmgr/deadlock.c  |  9 +++---
src/backend/storage/lmgr/lock.c      |  6 ++--
src/backend/storage/lmgr/proc.c      | 12 ++++----
5 files changed, 53 insertions(+), 47 deletions(-)


pgsql-committers by date:

Previous
From: Bruce Momjian
Date:
Subject: pgsql: docs: use alias in WHERE clause of full text search example
Next
From: Noah Misch
Date:
Subject: pgsql: Fix cosmetic blemishes involving rd_createSubid.