]> granicus.if.org Git - postgresql/commit
Make VACUUM VERBOSE report the number of skipped frozen pages.
authorFujii Masao <fujii@postgresql.org>
Fri, 24 Mar 2017 17:39:44 +0000 (02:39 +0900)
committerFujii Masao <fujii@postgresql.org>
Fri, 24 Mar 2017 17:39:44 +0000 (02:39 +0900)
commit70adf2fbe18f83f34b576ee83f42ea9d28375bf0
tree63c9b24e8708b5ae1a69618ddd93d7dcd2349f39
parent7b504eb282ca2f5104b5c00b4f05a3ef6bb1385b
Make VACUUM VERBOSE report the number of skipped frozen pages.

Previously manual VACUUM did not report the number of skipped frozen
pages even when VERBOSE option is specified. But this information is
helpful to monitor the VACUUM activity, and also autovacuum reports that
number in the log file when the condition of log_autovacuum_min_duration
is met.

This commit changes VACUUM VERBOSE so that it reports the number
of frozen pages that it skips.

Author: Masahiko Sawada
Reviewed-by: Yugo Nagata and Jim Nasby
Discussion: http://postgr.es/m/CAD21AoDZQKCxo0L39Mrq08cONNkXQKXuh=2DP1Q8ebmt35SoaA@mail.gmail.com
doc/src/sgml/ref/vacuum.sgml
src/backend/commands/vacuumlazy.c