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

From Alvaro Herrera
Subject Re: Autovacuum launcher doesn't notice death of postmaster immediately
Date
Msg-id 20070608132726.GD9071@alvh.no-ip.org
Whole thread Raw
In response to Re: Autovacuum launcher doesn't notice death of postmaster immediately  ("Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>)
Responses Re: Autovacuum launcher doesn't notice death of postmaster immediately  ("Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>)
List 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.


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: COPYable logs status
Next
From: Martijn van Oosterhout
Date:
Subject: Re: COPYable logs status