Content-Length: 264515 | pFad | http://github.com/postgrespro/postgres/commit/1a8e72bff781e869e5b5dc76fa18e3ae08181656

AC Doc: update VACUUM VERBOSE freezing tip. · postgrespro/postgres@1a8e72b · GitHub
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)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/1a8e72bff781e869e5b5dc76fa18e3ae08181656

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy