Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit05023a2

Browse files
Doc: Add relfrozenxid Tip to XID wraparound section.
VACUUM VERBOSE and autovacuum log reports were taught to report thedetails of how VACUUM advanced relfrozenxid (and relminmxid) by commit872770f. Highlight this by adding a "Tip" to the documentation, nextto related discussion of age(relfrozenxid) monitoring.Author: Peter Geoghegan <pg@bowt.ie>Discussion:https://postgr.es/m/CAH2-Wzk0C1O-MKkOrj4YAfsGRru2=cA2VQpqM-9R1HNuG3nFaQ@mail.gmail.com
1 parente39f990 commit05023a2

File tree

1 file changed

+13
-0
lines changed

1 file changed

+13
-0
lines changed

‎doc/src/sgml/maintenance.sgml

Lines changed: 13 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -611,6 +611,19 @@ SELECT datname, age(datfrozenxid) FROM pg_database;
611611
cutoff XID to the current transaction's XID.
612612
</para>
613613

614+
<tip>
615+
<para>
616+
When the <command>VACUUM</command> command's <literal>VERBOSE</literal>
617+
parameter is specified, <command>VACUUM</command> prints various
618+
statistics about the table. This includes information about how
619+
<structfield>relfrozenxid</structfield> and
620+
<structfield>relminmxid</structfield> advanced. The same details appear
621+
in the server log when autovacuum logging (controlled by <xref
622+
linkend="guc-log-autovacuum-min-duration"/>) reports on a
623+
<command>VACUUM</command> operation executed by autovacuum.
624+
</para>
625+
</tip>
626+
614627
<para>
615628
<command>VACUUM</command> normally only scans pages that have been modified
616629
since the last vacuum, but <structfield>relfrozenxid</structfield> can only be

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp