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

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andrew Hammond <andrew(dot)george(dot)hammond(at)gmail(dot)com>, "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, 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-07 20:24:58
Message-ID: 4668699A.5030906@zeut.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Tom Lane wrote:
> "Andrew Hammond" <andrew(dot)george(dot)hammond(at)gmail(dot)com> writes:
>> Hmmm... it seems to me that points new users towards not using
>> autovacuum, which doesn't seem like the best idea. I think it'd be
>> better to say that setting the naptime really high is a Bad Idea.
>
> It seems like we should have an upper limit on the GUC variable that's
> less than INT_MAX ;-). Would an hour be sane? 10 minutes?
>
> This is independent of the problem at hand, though, which is that we
> probably want the launcher to notice postmaster death in less time
> than autovacuum_naptime, for reasonable values of same.

Do we need a configurable autovacuum naptime at all? I know I put it in
the original contrib autovacuum because I had no idea what knobs might
be needed. I can't see a good reason to ever have a naptime longer than
the default 60 seconds, but I suppose one might want a smaller naptime
for a very active system?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Smith 2007-06-07 20:49:17 Re: Controlling Load Distributed Checkpoints
Previous Message Gregory Stark 2007-06-07 19:28:27 Re: Controlling Load Distributed Checkpoints

Browse pgsql-patches by date

  From Date Subject
Next Message Greg Smith 2007-06-07 20:49:17 Re: Controlling Load Distributed Checkpoints
Previous Message Gregory Stark 2007-06-07 19:28:27 Re: Controlling Load Distributed Checkpoints