Horton

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

Zeugswetter Andreas DCP SD <zeugswettera@spardat.at>

View thread View on postgr.es
From: "Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>
To: "Alvaro Herrera" <alvherre@commandprompt.com>
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-08T14:57:59Z
Lists: pgsql-hackers 
> > > > > 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).

No, I meant a "while (sleep 1(or 10) and counter < longtime) check for
exit" instead of "sleep longtime".

Andreas