]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Remove replication slot advice from MultiXact wraparound hints
authorFujii Masao <fujii@postgresql.org>
Fri, 3 Jul 2026 02:16:34 +0000 (11:16 +0900)
committerFujii Masao <fujii@postgresql.org>
Fri, 3 Jul 2026 02:16:34 +0000 (11:16 +0900)
commit084734ff5a4249f0095771ee1addedbd41a88a18
tree32265c3fb85b9b129f7775c457d3a519a4ddafa6
parentc8bd8387c27ab0e60a7864d231f06e8c3fdbfa8d
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
doc/src/sgml/maintenance.sgml
src/backend/access/transam/multixact.c
src/backend/commands/vacuum.c