pgsql: Avoid spurious wait in concurrent reindex - Mailing list pgsql-committers

From Alvaro Herrera
Subject pgsql: Avoid spurious wait in concurrent reindex
Date
Msg-id E1l0PFP-0007R3-Oj@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Avoid spurious wait in concurrent reindex

This is like commit c98763bf51bf, but for REINDEX CONCURRENTLY.  To wit:
this flags indicates that the current process is safe to ignore for the
purposes of waiting for other snapshots, when doing CREATE INDEX
CONCURRENTLY and REINDEX CONCURRENTLY.  This helps two processes doing
either of those things not deadlock, and also avoids spurious waits.

Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
Reviewed-by: Dmitry Dolgov <9erthalion6@gmail.com>
Reviewed-by: Hamid Akhtar <hamid.akhtar@gmail.com>
Reviewed-by: Masahiko Sawada <sawada.mshk@gmail.com>
Discussion: https://postgr.es/m/20201130195439.GA24598@alvherre.pgsql

Branch
------
master

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

Modified Files
--------------
src/backend/commands/indexcmds.c | 48 +++++++++++++++++++++++++++++++++++++++-
src/include/storage/proc.h       |  1 +
2 files changed, 48 insertions(+), 1 deletion(-)


pgsql-committers by date:

Previous
From: Fujii Masao
Date:
Subject: pgsql: Fix calculation of how much shared memory is required to store a
Next
From: Tom Lane
Date:
Subject: pgsql: Improve our heuristic for selecting PG_SYSROOT on macOS.