| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Zeugswetter Andreas ADI SD <ZeugswetterA(at)spardat(dot)at> |
| Cc: | Andrew Hammond <andrew(dot)george(dot)hammond(at)gmail(dot)com>, "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Autovacuum launcher doesn't notice death of postmaster immediately |
| Date: | 2007-06-08 13:27:26 |
| Message-ID: | 20070608132726.GD9071@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2007-06-08 13:35:12 | Re: COPYable logs status |
| Previous Message | Alvaro Herrera | 2007-06-08 13:11:25 | Re: COPYable logs status |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2007-06-08 13:35:12 | Re: COPYable logs status |
| Previous Message | Alvaro Herrera | 2007-06-08 13:11:25 | Re: COPYable logs status |