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

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Zeugswetter Andreas ADI SD <ZeugswetterA(at)spardat(dot)at>, 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-12 10:23:50
Message-ID: 466E7436.5070000@sun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Alvaro Herrera wrote:
> 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).
>> No, I meant a "while (sleep 1(or 10) and counter < longtime) check for
>> exit" instead of "sleep longtime".
>
> Ah; yes, what I was proposing (or thought about proposing, not sure if I
> posted it or not) was putting a upper limit of 10 seconds in the sleep
> (bgwriter sleeps 10 seconds if configured to not do anything). Though
> 10 seconds may seem like an eternity for systems like the ones Peter was
> talking about, where there is a script trying to restart the server as
> soon as the postmaster dies.

There is also one "wild" solution. Postmaster and bgwriter will connect
with socket/pipe and select command will be used instead sleep. If
connection unexpectedly fails, select finish immediately and we are able
to handle this issue asap. This socket should be used also in some
special case when we need wake up it faster.

Zdenek

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2007-06-12 10:30:57 Re: Selecting a constant question
Previous Message Zeugswetter Andreas ADI SD 2007-06-12 09:37:56 Re: Selecting a constant question

Browse pgsql-patches by date

  From Date Subject
Next Message Magnus Hagander 2007-06-12 10:37:29 Re: Autovacuum launcher doesn't notice death of postmaster immediately
Previous Message ITAGAKI Takahiro 2007-06-12 08:35:55 Re: Autovacuum launcher doesn't notice death of postmaster immediately