agora inbox for pgsql-committers@postgresql.org
help / color / mirror / Atom feedFrom: Fujii Masao <fujii@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Remove replication slot advice from MultiXact wraparound hints
Date: Fri, 03 Jul 2026 02:23:55 +0000
Message-ID: <E1wfTZL-0017sA-23@gemulon.postgresql.org> (raw)
Remove replication slot advice from MultiXact wraparound hints
Previously, MultiXactId wraparound hints suggested dropping stale
replication slots. While that advice is appropriate for transaction ID
wraparound, where replication slots can hold back XID horizons,
it was misleading for MultiXactId wraparound. Following it could lead
users to drop replication slots unnecessarily without helping resolve
the MultiXactId wraparound condition.
MultiXact cleanup is not directly delayed by replication slots.
Instead, it depends on whether old MultiXactIds can still be seen
as live by running transactions.
This commit removes the replication slot advice from MultiXactId
wraparound hints, and documents that stale replication slots are
normally not relevant to resolving MultiXactId wraparound problems.
Backpatch to all supported branches.
BUG #18876
Reported-by: Haruka Takatsuka <harukat@sraoss.co.jp>
Author: Fujii Masao <masao.fujii@gmail.com>
Discussion: https://postgr.es/m/18876-0d0b53bad5a1f4c1@postgresql.org
Backpatch-through: 14
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/084734ff5a4249f0095771ee1addedbd41a88a18
Modified Files
--------------
doc/src/sgml/maintenance.sgml | 6 ++++++
src/backend/access/transam/multixact.c | 12 ++++++------
src/backend/commands/vacuum.c | 2 +-
3 files changed, 13 insertions(+), 7 deletions(-)
view thread (7+ messages) latest in thread
Message-ID: <E1wfTZL-0017sA-23@gemulon.postgresql.org>
Permalink: ../E1wfTZL-0017sA-23@gemulon.postgresql.org/
Also on: postgresql.org/message-id/E1wfTZL-0017sA-23@gemulon.postgresql.org
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: fujii@postgresql.org, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Remove replication slot advice from MultiXact wraparound hints
In-Reply-To: <E1wfTZL-0017sA-23@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox