Re: Autovacuum launcher doesn't notice death of postmaster immediately

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: Autovacuum launcher doesn't notice death of postmaster immediately
Дата
Msg-id 20070607155036.GH92628@nasby.net
обсуждение исходный текст
Ответ на Re: Autovacuum launcher doesn't notice death of postmaster immediately  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Autovacuum launcher doesn't notice death of postmaster immediately  ("Andrew Hammond" <andrew.george.hammond@gmail.com>)
Список pgsql-hackers
On Mon, Jun 04, 2007 at 11:04:26AM -0400, Alvaro Herrera wrote:
> The launcher is set up to wake up in autovacuum_naptime seconds at most.
> So if the user configures a ridiculuos time (for example 86400 seconds,
> which I've seen) then the launcher would not detect the postmaster death

Yeah, I've seen people set that up with the intention of "now autovacuum
will only run during our slow time!". I'm thinking it'd be worth
mentioning in the docs that this won't work, and instead suggesting that
they run vacuumdb -a or equivalent at that time instead. Thoughts?
--
Jim Nasby                                      decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Create a GUC parametertemp_tablespacesthat allows selection of
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [PATCHES] [BUGS] BUG #3326: Invalid lower bound of autovacuum_cost_limit