diff options
| -rw-r--r-- | doc/src/sgml/maintenance.sgml | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/doc/src/sgml/maintenance.sgml b/doc/src/sgml/maintenance.sgml index 5f3b6720e41..84fba9dcb10 100644 --- a/doc/src/sgml/maintenance.sgml +++ b/doc/src/sgml/maintenance.sgml @@ -611,6 +611,19 @@ SELECT datname, age(datfrozenxid) FROM pg_database; cutoff XID to the current transaction's XID. </para> + <tip> + <para> + When the <command>VACUUM</command> command's <literal>VERBOSE</literal> + parameter is specified, <command>VACUUM</command> prints various + statistics about the table. This includes information about how + <structfield>relfrozenxid</structfield> and + <structfield>relminmxid</structfield> advanced. The same details appear + in the server log when autovacuum logging (controlled by <xref + linkend="guc-log-autovacuum-min-duration"/>) reports on a + <command>VACUUM</command> operation executed by autovacuum. + </para> + </tip> + <para> <command>VACUUM</command> normally only scans pages that have been modified since the last vacuum, but <structfield>relfrozenxid</structfield> can only be |