At Thu, 5 Oct 2017 13:41:42 +0200, Alvaro Herrera <alvhe...@alvh.no-ip.org> wrote in <20171005114142.dupjeqe2cnplhgkx@alvherre.pgsql> > 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.
Thanks! Will do after a bit time of organization of the thougts. reagareds, -- Kyotaro Horiguchi NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers