Re: pgsql: Improve autovacuum logging for aggressive and anti-wraparound ru

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: pgsql: Improve autovacuum logging for aggressive and anti-wraparound ru
Дата
Msg-id 23209391537822541@iva4-6d7004ac8463.qloud-c.yandex.net
обсуждение исходный текст
Ответ на Re: pgsql: Improve autovacuum logging for aggressive andanti-wraparound ru  ("Nasby, Jim" <nasbyj@amazon.com>)
Ответы Re: pgsql: Improve autovacuum logging for aggressive andanti-wraparound ru  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
Hi

> An autovacuum can't be just aggressive; it's either anti-wraparound or normal.
But autovacuum _can_ be aggressive and not anti-wraparound.
I build current master and can see 3 different line types:
2018-09-24 23:47:31.500 MSK 27939 @ from  [vxid:4/272032 txid:0] [] LOG:  automatic aggressive vacuum of table
"postgres.public.foo":index scans: 0
 
2018-09-24 23:49:27.892 MSK 28333 @ from  [vxid:4/284297 txid:0] [] LOG:  automatic aggressive vacuum to prevent
wraparoundof table "postgres.public.foo": index scans: 0
 
2018-09-24 23:49:29.093 MSK 28337 @ from  [vxid:4/284412 txid:0] [] LOG:  automatic vacuum of table
"postgres.public.foo":index scans: 0
 

regards, Sergei


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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: auto_explain: Include JIT output if applicable
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: [PATCH] Include application_name in "connection authorized" logmessage