From: | Glen Parker <glenebob(at)nwlink(dot)com> |
---|---|
To: | Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Autovacuum Improvements |
Date: | 2006-12-19 22:09:10 |
Message-ID: | 45886306.1040009@nwlink.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Erik Jones wrote:
> Matthew O'Connor wrote:
>> Glen Parker wrote:
>>> If it isn't there somewhere already, I would ask to add:
>>> 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.
>
> Well, what he's saying is, "Not taking into account any time/maintenance
> windows, does this table need vacuuming?"
Correct. IOW, "does it need it?", not "would you actually do it at this
time?"...
-Glen
From | Date | Subject | |
---|---|---|---|
Next Message | Glen Parker | 2006-12-19 22:11:41 | Re: Autovacuum Improvements |
Previous Message | Bruce Momjian | 2006-12-19 21:57:24 | Re: Autovacuum Improvements |
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2006-12-19 22:09:20 | Re: effective_cache_size vs units |
Previous Message | Magnus Hagander | 2006-12-19 22:08:47 | Re: effective_cache_size vs units |