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 по дате отправления: