Skip to content

Commit 1a8e72b

Browse files
Doc: update VACUUM VERBOSE freezing tip.
VACUUM VERBOSE/autovacuuming logging have reported on the number of pages frozen by VACUUM since commit d977ffd added that capability. This information is directly related to relfrozenxid advancement, so update an older tip from the documentation about how relfrozenxid is reported on by the same instrumentation code. Now the tip directly mentions newly frozen pages, too.
1 parent 4d41799 commit 1a8e72b

File tree

1 file changed

+3
-2
lines changed

1 file changed

+3
-2
lines changed

doc/src/sgml/maintenance.sgml

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -643,8 +643,9 @@ SELECT datname, age(datfrozenxid) FROM pg_database;
643643
parameter is specified, <command>VACUUM</command> prints various
644644
statistics about the table. This includes information about how
645645
<structfield>relfrozenxid</structfield> and
646-
<structfield>relminmxid</structfield> advanced. The same details appear
647-
in the server log when autovacuum logging (controlled by <xref
646+
<structfield>relminmxid</structfield> advanced, and the number of
647+
newly frozen pages. The same details appear in the server log when
648+
autovacuum logging (controlled by <xref
648649
linkend="guc-log-autovacuum-min-duration"/>) reports on a
649650
<command>VACUUM</command> operation executed by autovacuum.
650651
</para>

0 commit comments

Comments
 (0)