pgsql: Rethink the delay-checkpoint-end mechanism in the back-branches. - Mailing list pgsql-committers

From Robert Haas
Subject pgsql: Rethink the delay-checkpoint-end mechanism in the back-branches.
Date
Msg-id E1nf17v-000Uq3-Ts@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Rethink the delay-checkpoint-end mechanism in the back-branches.

The back-patch of commit bbace5697df12398e87ffd9879171c39d27f5b33 had
the unfortunate effect of changing the layout of PGPROC in the
back-branches, which could break extensions. This happened because it
changed the delayChkpt from type bool to type int. So, change it back,
and add a new bool delayChkptEnd field instead. The new field should
fall within what used to be padding space within the struct, and so
hopefully won't cause any extensions to break.

Per report from Markus Wanner and discussion with Tom Lane and others.

Patch originally by me, somewhat revised by Markus Wanner per a
suggestion from Michael Paquier. A very similar patch was developed
by Kyotaro Horiguchi, but I failed to see the email in which that was
posted before writing one of my own.

Discussion: http://postgr.es/m/CA+Tgmoao-kUD9c5nG5sub3F7tbo39+cdr8jKaOVEs_1aBWcJ3Q@mail.gmail.com
Discussion: http://postgr.es/m/20220406.164521.17171257901083417.horikyota.ntt@gmail.com

Branch
------
REL_13_STABLE

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

Modified Files
--------------
src/backend/access/transam/multixact.c  |  6 +--
src/backend/access/transam/twophase.c   | 15 +++---
src/backend/access/transam/xact.c       |  6 +--
src/backend/access/transam/xlog.c       | 10 ++--
src/backend/access/transam/xloginsert.c |  2 +-
src/backend/catalog/storage.c           |  6 +--
src/backend/storage/buffer/bufmgr.c     |  6 +--
src/backend/storage/ipc/procarray.c     | 96 +++++++++++++++++++++++++--------
src/include/storage/proc.h              | 35 ++----------
src/include/storage/procarray.h         |  7 ++-
10 files changed, 109 insertions(+), 80 deletions(-)


pgsql-committers by date:

Previous
From: Andrew Dunstan
Date:
Subject: pgsql: Improve a couple of sql/json error messages
Next
From: Tom Lane
Date:
Subject: pgsql: Temporarily add some probes of tenk1's relallvisible in create_i