From: | Matthew O'Connor <matthew(at)zeut(dot)net> |
---|---|
To: | Matthew O'Connor <matthew(at)zeut(dot)net>, Glen Parker <glenebob(at)nwlink(dot)com>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Autovacuum Improvements |
Date: | 2006-12-19 22:34:10 |
Message-ID: | 458868E2.2030205@zeut.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Alvaro Herrera wrote:
> Matthew O'Connor wrote:
>> Glen Parker wrote:
>>> 5) Expose a very easy way to discover autovacuum's opinion about a
>>> particular table, for example "table_needs_vacuum(oid)", ignoring any
>>> time constraints that may be in place.
>> This might be a nice feature however in the presence of the much talked
>> about but not yet developed maintenance window concept, I'm not sure how
>> this should work. That is, during business hours the table doesn't
>> need vacuuming, but it will when the evening maintenance window opens up.
>
> I intend to work on the maintenance window idea for 8.3. I'm not sure
> if I'll be able to introduce the worker process stuff in there as well.
> I actually haven't done much design on the stuff so I can't say.
>
> Now, if you (Matthew, or Glen as well!) were to work on that it'll be
> appreciated ;-) and we could team up.
I would like to get back into working on autovacuum, outside of
discussions on the lists I haven't done anything since you took it from
contrib. Anyway I am interested in helping if I can find the time but
there is no chance of that happening in the next few weeks, but maybe in
January.
I think another thing to consider are good default values for the
autovacuum vacuum delay settings. We talked about this a while ago, but
I don't think we ever settled on anything.
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew O'Connor | 2006-12-19 22:36:30 | Re: Autovacuum Improvements |
Previous Message | Alvaro Herrera | 2006-12-19 22:18:25 | Re: Autovacuum Improvements |
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew O'Connor | 2006-12-19 22:36:30 | Re: Autovacuum Improvements |
Previous Message | Kenneth Marshall | 2006-12-19 22:20:58 | Re: effective_cache_size vs units |