Re: Doubt on content under Routine Vacuuming section

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Doubt on content under Routine Vacuuming section
Дата
Msg-id 194d68d70a31bd8523dd6dd578ef91dea6a6dfef.camel@cybertec.at
обсуждение исходный текст
Ответ на Doubt on content under Routine Vacuuming section  (PG Doc comments form <noreply@postgresql.org>)
Ответы Re: Doubt on content under Routine Vacuuming section
Список pgsql-docs
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.

Yours,
Laurenz Albe

Вложения

В списке pgsql-docs по дате отправления: