From: | Michael Paesold <mpaesold(at)gmx(dot)at> |
---|---|
To: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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-08 07:54:09 |
Message-ID: | 46690B21.60104@gmx.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Matthew T. O'Connor schrieb:
> 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?
A PostgreSQL database on my laptop for testing. It should use as little
resources as possible while being idle. That would be a scenario for
naptime greater than 60 seconds, wouldn't it?
Best Regards
Michael Paesold
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas ADI SD | 2007-06-08 08:12:52 | Re: Autovacuum launcher doesn't notice death of postmaster immediately |
Previous Message | Gregory Stark | 2007-06-08 05:39:58 | Re: TOAST usage setting |
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas ADI SD | 2007-06-08 08:12:52 | Re: Autovacuum launcher doesn't notice death of postmaster immediately |
Previous Message | Tom Lane | 2007-06-08 04:09:20 | Re: Synchronized scans |