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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: can't stop autovacuum by HUP'ing the server
Дата
Msg-id 10178.1219770048@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
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> If it doesn't ignore them, then it should be properly vacuuming
> template0 as any other database.  We've changed autovac's behavior on
> this area back and forth so I may be misremembering what's our rationale
> du jour.

AFAICS, the only way in which current autovac treats !datallowconn
databases specially is this test in do_autovacuum:
if (dbForm->datistemplate || !dbForm->datallowconn)    default_freeze_min_age = 0;else    default_freeze_min_age =
vacuum_freeze_min_age;

Perhaps there's something wrong with the idea of setting freeze_min_age
to zero?
        regards, tom lane


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

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