public inbox for [email protected]  

help / color / mirror / Atom feed

From: Robert Treat <[email protected]>
To: Laurenz Albe <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: Doubt on content under Routine Vacuuming section
Date: Wed, 7 Jan 2026 23:36:07 -0500
Message-ID: <CABV9wwMz7pi0xFc+CdMijWVqQGMQAL+2a0h9s9_QBuG2uC0KPg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <176767268098.1084085.10345048667224193115@wrigleys.postgresql.org>
	<[email protected]>

On Tue, Jan 6, 2026 at 4:53 AM Laurenz Albe <[email protected]> wrote:
> On Tue, 2026-01-06 at 04:11 +0000, PG Doc comments form wrote:
> > https://www.postgresql.org/docs/current/routine-vacuuming.html#ROUTINE-VACUUMING
> > There are five points under this section;
> >  "In this condition any transactions already in progress can continue, but
> > only read-only transactions can be started. Operations that modify database
> > records or truncate relations will fail. The VACUUM command can still be run
> > normally. Note that, contrary to what was sometimes recommended in earlier
> > releases, it is not necessary or desirable to stop the postmaster or enter
> > single user-mode in order to restore normal operation. Instead, follow these
> > steps:..."
> >
> > 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 been
> > 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.
> >
> > Please check if my observation is correct or not.
>
> You are correct.  Attached is a patch that fixes the documentation.
>

+1 on the fix, and the adding of the structname's.

Given the commit that introduced this was backpatched to v14, ISTM
this should probably be backpatched as well.


Robert Treat
https://xzilla.net

view thread (5+ messages)  latest in thread

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: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Doubt on content under Routine Vacuuming section
  In-Reply-To: <CABV9wwMz7pi0xFc+CdMijWVqQGMQAL+2a0h9s9_QBuG2uC0KPg@mail.gmail.com>

* 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