pgsql: Allow page lock to conflict among parallel group members.

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема pgsql: Allow page lock to conflict among parallel group members.
Дата
Msg-id E1jFUmx-0004N0-Qe@gemulon.postgresql.org
обсуждение исходный текст
Ответы Re: pgsql: Allow page lock to conflict among parallel group members.  (Andres Freund <andres@anarazel.de>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: pgsql: docs: use alias in WHERE clause of full text search example
Следующее
От: Noah Misch
Дата:
Сообщение: pgsql: Fix cosmetic blemishes involving rd_createSubid.