Message-ID: <194d68d70a31bd8523dd6dd578ef91dea6a6dfef.camel@cybertec.at>
Subject: Re: Doubt on content under Routine Vacuuming section
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: sanjaya.waruna@gmail.com, pgsql-docs@lists.postgresql.org
Date: Tue, 06 Jan 2026 10:53:34 +0100
In-Reply-To: 
 <176767268098.1084085.10345048667224193115@wrigleys.postgresql.org>
References: 
	<176767268098.1084085.10345048667224193115@wrigleys.postgresql.org>
Content-Type: multipart/mixed; boundary="=-hhcL/AdYoznfcWenIpb/"
User-Agent: Evolution 3.58.2 (3.58.2-1.fc43) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/194d68d70a31bd8523dd6dd578ef91dea6a6dfef.camel%40cybertec.at>
Precedence: bulk

--=-hhcL/AdYoznfcWenIpb/
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, 2026-01-06 at 04:11 +0000, PG Doc comments form wrote:
> https://www.postgresql.org/docs/current/routine-vacuuming.html#ROUTINE-VA=
CUUMING
> There are five points under this section;
>  "In this condition any transactions already in progress can continue, bu=
t
> only read-only transactions can be started. Operations that modify databa=
se
> records or truncate relations will fail. The VACUUM command can still be =
run
> normally. Note that, contrary to what was sometimes recommended in earlie=
r
> releases, it is not necessary or desirable to stop the postmaster or ente=
r
> single user-mode in order to restore normal operation. Instead, follow th=
ese
> steps:..."
>=20
> In the third point it says "Use pg_stat_replication to find slots where
> age(xmin) or age(catalog_xmin) is large. In many cases, such slots were
> created for replication to servers that no longer exist, or that have bee=
n
> down for a long time."
> However, those columns, ie: xmin and catalog_xmin exists in
> pg_replication_slots metadata view. :
> https://www.postgresql.org/docs/18/view-pg-replication-slots.html
> Not in the pg_stat_replication.
>=20
> Please check if my observation is correct or not.

You are correct.  Attached is a patch that fixes the documentation.

Yours,
Laurenz Albe

--=-hhcL/AdYoznfcWenIpb/
Content-Disposition: attachment;
	filename*0=v1-0001-Fix-doc-for-recovering-from-approaching-xid-wrapa.pat;
	filename*1=ch
Content-Type: text/x-patch;
	name="v1-0001-Fix-doc-for-recovering-from-approaching-xid-wrapa.patch";
	charset="UTF-8"
Content-Transfer-Encoding: base64

RnJvbSAwOTE0ZDQwY2FhNTZjYTFhMjE2YzIwNmRlZDU1MDdiMjZlMGI0MGQ1IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h
dD4KRGF0ZTogVHVlLCA2IEphbiAyMDI2IDEwOjUxOjMwICswMTAwClN1YmplY3Q6IFtQQVRDSCB2
MV0gRml4IGRvYyBmb3IgcmVjb3ZlcmluZyBmcm9tIGFwcHJvYWNoaW5nIHhpZCB3cmFwYXJvdW5k
CgpDb21taXQgYTcwYmNlNDNmYiBhZGRlZCBpbnN0cnVjdGlvbnMgaG93IHRvIHJlY292ZXIgaWYg
UG9zdGdyZVNRTCByZWZ1c2VzCnRvIGlzc3VlIG5ldyB0cmFuc2FjdGlvbiBJRHMgYmVjYXVzZSBv
ZiBpbW1pbmVudCB3cmFwYXJvdW5kLCBidXQgcmVmZXJyZWQKdG8gcGdfc3RhdF9yZXBsaWNhdGlv
biB3aGVyZSBpdCBzaG91bGQgaGF2ZSByZWZlcmVuY2VkIHBnX3JlcGxpY2F0aW9uX3Nsb3RzLgoK
SW4gcGFzc2luZywgZGVjb3JhdGUgcmVmZXJlbmNlcyB0byB2aWV3cyB3aXRoIDxzdHJ1Y3RuYW1l
PiB0YWdzLgoKQXV0aG9yOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD4K
UmVwb3J0ZWQtQnk6IFNhbmpheWEgV2FydW5hIDxzYW5qYXlhLndhcnVuYUBnbWFpbC5jb20+CkRp
c2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMTc2NzY3MjY4MDk4LjEwODQwODUuMTAzNDUw
NDg2NjcyMjQxOTMxMTVAd3JpZ2xleXMucG9zdGdyZXNxbC5vcmcKLS0tCiBkb2Mvc3JjL3NnbWwv
bWFpbnRlbmFuY2Uuc2dtbCB8IDYgKysrLS0tCiAxIGZpbGUgY2hhbmdlZCwgMyBpbnNlcnRpb25z
KCspLCAzIGRlbGV0aW9ucygtKQoKZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9tYWludGVuYW5j
ZS5zZ21sIGIvZG9jL3NyYy9zZ21sL21haW50ZW5hbmNlLnNnbWwKaW5kZXggMDhlNjQ4OWFmYjgu
LjUwYzcyZWIzMGMzIDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvbWFpbnRlbmFuY2Uuc2dtbAor
KysgYi9kb2Mvc3JjL3NnbWwvbWFpbnRlbmFuY2Uuc2dtbApAQCAtNzAxLDIwICs3MDEsMjAgQEAg
SElOVDogIEV4ZWN1dGUgYSBkYXRhYmFzZS13aWRlIFZBQ1VVTSBpbiB0aGF0IGRhdGFiYXNlLgog
ICAgIDxvcmRlcmVkbGlzdD4KICAgICAgPGxpc3RpdGVtPgogICAgICAgPHNpbXBhcmE+UmVzb2x2
ZSBvbGQgcHJlcGFyZWQgdHJhbnNhY3Rpb25zLiBZb3UgY2FuIGZpbmQgdGhlc2UgYnkgY2hlY2tp
bmcKLSAgICAgICA8bGluayBsaW5rZW5kPSJ2aWV3LXBnLXByZXBhcmVkLXhhY3RzIj5wZ19wcmVw
YXJlZF94YWN0czwvbGluaz4gZm9yIHJvd3Mgd2hlcmUKKyAgICAgICA8bGluayBsaW5rZW5kPSJ2
aWV3LXBnLXByZXBhcmVkLXhhY3RzIj48c3RydWN0bmFtZT5wZ19wcmVwYXJlZF94YWN0czwvc3Ry
dWN0bmFtZT48L2xpbms+IGZvciByb3dzIHdoZXJlCiAgICAgICAgPGxpdGVyYWw+YWdlKHRyYW5z
YWN0aW9uaWQpPC9saXRlcmFsPiBpcyBsYXJnZS4gU3VjaCB0cmFuc2FjdGlvbnMgc2hvdWxkIGJl
CiAgICAgICAgY29tbWl0dGVkIG9yIHJvbGxlZCBiYWNrLjwvc2ltcGFyYT4KICAgICAgPC9saXN0
aXRlbT4KICAgICAgPGxpc3RpdGVtPgogICAgICAgPHNpbXBhcmE+RW5kIGxvbmctcnVubmluZyBv
cGVuIHRyYW5zYWN0aW9ucy4gWW91IGNhbiBmaW5kIHRoZXNlIGJ5IGNoZWNraW5nCi0gICAgICAg
PGxpbmsgbGlua2VuZD0ibW9uaXRvcmluZy1wZy1zdGF0LWFjdGl2aXR5LXZpZXciPnBnX3N0YXRf
YWN0aXZpdHk8L2xpbms+IGZvciByb3dzIHdoZXJlCisgICAgICAgPGxpbmsgbGlua2VuZD0ibW9u
aXRvcmluZy1wZy1zdGF0LWFjdGl2aXR5LXZpZXciPjxzdHJ1Y3RuYW1lPnBnX3N0YXRfYWN0aXZp
dHk8L3N0cnVjdG5hbWU+PC9saW5rPiBmb3Igcm93cyB3aGVyZQogICAgICAgIDxsaXRlcmFsPmFn
ZShiYWNrZW5kX3hpZCk8L2xpdGVyYWw+IG9yIDxsaXRlcmFsPmFnZShiYWNrZW5kX3htaW4pPC9s
aXRlcmFsPiBpcwogICAgICAgIGxhcmdlLiBTdWNoIHRyYW5zYWN0aW9ucyBzaG91bGQgYmUgY29t
bWl0dGVkIG9yIHJvbGxlZCBiYWNrLCBvciB0aGUgc2Vzc2lvbgogICAgICAgIGNhbiBiZSB0ZXJt
aW5hdGVkIHVzaW5nIDxsaXRlcmFsPnBnX3Rlcm1pbmF0ZV9iYWNrZW5kPC9saXRlcmFsPi48L3Np
bXBhcmE+CiAgICAgIDwvbGlzdGl0ZW0+CiAgICAgIDxsaXN0aXRlbT4KICAgICAgIDxzaW1wYXJh
PkRyb3AgYW55IG9sZCByZXBsaWNhdGlvbiBzbG90cy4gVXNlCi0gICAgICAgPGxpbmsgbGlua2Vu
ZD0ibW9uaXRvcmluZy1wZy1zdGF0LXJlcGxpY2F0aW9uLXZpZXciPnBnX3N0YXRfcmVwbGljYXRp
b248L2xpbms+IHRvCisgICAgICAgPGxpbmsgbGlua2VuZD0idmlldy1wZy1yZXBsaWNhdGlvbi1z
bG90cyI+PHN0cnVjdG5hbWU+cGdfcmVwbGljYXRpb25fc2xvdHM8L3N0cnVjdG5hbWU+PC9saW5r
PiB0bwogICAgICAgIGZpbmQgc2xvdHMgd2hlcmUgPGxpdGVyYWw+YWdlKHhtaW4pPC9saXRlcmFs
PiBvciA8bGl0ZXJhbD5hZ2UoY2F0YWxvZ194bWluKTwvbGl0ZXJhbD4KICAgICAgICBpcyBsYXJn
ZS4gSW4gbWFueSBjYXNlcywgc3VjaCBzbG90cyB3ZXJlIGNyZWF0ZWQgZm9yIHJlcGxpY2F0aW9u
IHRvIHNlcnZlcnMgdGhhdCBubwogICAgICAgIGxvbmdlciBleGlzdCwgb3IgdGhhdCBoYXZlIGJl
ZW4gZG93biBmb3IgYSBsb25nIHRpbWUuIElmIHlvdSBkcm9wIGEgc2xvdCBmb3IgYSBzZXJ2ZXIK
LS0gCjIuNTIuMAoK


--=-hhcL/AdYoznfcWenIpb/--