Horton

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

Alvaro Herrera <alvherre@commandprompt.com>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Zeugswetter Andreas ADI SD <ZeugswetterA@spardat.at>
Cc: Andrew Hammond <andrew.george.hammond@gmail.com>, "Jim C. Nasby" <decibel@decibel.org>, Peter Eisentraut <peter_e@gmx.net>, pgsql-hackers@postgresql.org
Date: 2007-06-08T13:27:26Z
Lists: pgsql-hackers 
Zeugswetter Andreas ADI SD escribió:
> 
> > > > The launcher is set up to wake up in autovacuum_naptime seconds at
> > > > most.
> 
> Imho the fix is usually to have a sleep loop.

This is what we have.  The sleep time depends on the schedule of next
vacuum for the closest database in time.  If naptime is high, the sleep
time will be high (depending on number of databases needing attention).

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.