pgsql: Fix parallel operations that prevent oldest xmin from advancing.

From: Amit Kapila <akapila(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix parallel operations that prevent oldest xmin from advancing.
Date: 2021-11-19 04:02:32
Message-ID: E1mnv6e-0003Qs-Eo@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix parallel operations that prevent oldest xmin from advancing.

While determining xid horizons, we skip over backends that are running
Vacuum. We also ignore Create Index Concurrently, or Reindex Concurrently
for the purposes of computing Xmin for Vacuum. But we were not setting the
flags corresponding to these operations when they are performed in
parallel which was preventing Xid horizon from advancing.

The optimization related to skipping Create Index Concurrently, or Reindex
Concurrently operations was implemented in PG-14 but the fix is the same
for the Parallel Vacuum as well so back-patched till PG-13.

Author: Masahiko Sawada
Reviewed-by: Amit Kapila
Backpatch-through: 13
Discussion: https://postgr.es/m/CAD21AoCLQqgM1sXh9BrDFq0uzd3RBFKi=Vfo6cjjKODm0Onr5w@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/0f0cfb494004befb0f6e89d3129347869420c509

Modified Files
--------------
src/backend/access/heap/vacuumlazy.c | 6 ++++++
src/backend/access/nbtree/nbtsort.c | 7 +++++++
src/backend/storage/ipc/procarray.c | 17 +++++++++++++++--
src/include/storage/proc.h | 7 +++++++
4 files changed, 35 insertions(+), 2 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2021-11-19 16:47:47 pgsql: Initialize backend status reporting during bootstrap.
Previous Message Michael Paquier 2021-11-19 02:03:13 pgsql: Improve psql tab completion for transforms, domains and sequence