Re: can't stop autovacuum by HUP'ing the server

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: can't stop autovacuum by HUP'ing the server
Дата
Msg-id 11261.1219772029@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: can't stop autovacuum by HUP'ing the server  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: can't stop autovacuum by HUP'ing the server  ("Dave Cramer" <pg@fastcrypt.com>)
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Dave Cramer wrote:
>> Well, I'm willing to help debug this, however this is a busy production
>> database and I need to be able to turn it off for a few hours a day. Would
>> changing autovacuum_freeze_max_age be a solution ?

> Yes.

Could we first see a cycle of autovac log output with
log_autovacuum_min_duration = 0?
Otherwise we're not going to get closer to understanding why it's
not cleaning up template0 for you.
        regards, tom lane


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: can't stop autovacuum by HUP'ing the server
Следующее
От: "Brendan Jurd"
Дата:
Сообщение: Re: Split up the wiki TODO page?