Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovacuum launcher doesn't notice death of postmaster immediately - Mailing list pgsql-hackers

From Jim C. Nasby
Subject Re: Autovacuum launcher doesn't notice death of postmaster immediately
Date
Msg-id 20070607155036.GH92628@nasby.net
Whole thread Raw
In response to Re: Autovacuum launcher doesn't notice death of postmaster immediately  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Autovacuum launcher doesn't notice death of postmaster immediately  ("Andrew Hammond" <andrew.george.hammond@gmail.com>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql: Create a GUC parametertemp_tablespacesthat allows selection of
Next
From: Alvaro Herrera
Date:
Subject: Re: [PATCHES] [BUGS] BUG #3326: Invalid lower bound of autovacuum_cost_limit