Kyotaro HORIGUCHI wrote: > # This reminded me of a concern. I'd like to count vacuums that > # are required but skipped by lock-failure, or killed by other > # backend.
We clearly need to improve the stats and logs related to vacuuming work executed, both by autovacuum and manually invoked. One other item I have in my head is to report numbers related to the truncation phase of a vacuum run, since in some cases it causes horrible and hard to diagnose problems. (Also, add an reloption to stop vacuum from doing the truncation phase at all -- for some usage patterns that is a serious problem.) However, please do open a new thread about it. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers