Re: pgsql: Improve autovacuum logging for aggressive andanti-wraparound ru

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: pgsql: Improve autovacuum logging for aggressive andanti-wraparound ru
Дата
Msg-id 20190330010822.GL1954@paquier.xyz
обсуждение исходный текст
Ответ на Re: pgsql: Improve autovacuum logging for aggressive andanti-wraparound ru  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: pgsql: Improve autovacuum logging for aggressive andanti-wraparound ru  (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>)
Список pgsql-hackers
On Fri, Mar 29, 2019 at 11:22:55AM -0300, Alvaro Herrera wrote:
> Yeah, that looks good to me too.  I wonder if we really need it as LOG
> though; we don't say anything for actions unless they take more than the
> min duration, so why say something for a no-op that takes almost no time?
> Maybe make it DEBUG1.

I think that this does not justify a WARNING, as that's harmless for
the user even if we use WARNING for other skips (see
vacuum_is_relation_owner).  However DEBUG1 is also too low in my
opinion as this log can be used as an indicator that autovacuum is too
much aggressive because there are too many workers for example.  I
have seen that matter in some CPU-bound environments.  I won't fight
hard if the consensus is to use DEBUG1 though.  So, more opinions?
Andrew perhaps?

> s/relfroxzenxid/relfrozenxid/

Sure.
--
Michael

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Unix socket dir, an idea
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: REINDEX CONCURRENTLY 2.0