Re: Autovacuum Improvements

Erik Jones <erik@myemma.com>

From: Erik Jones <erik@myemma.com>
To: Matthew O'Connor <matthew@zeut.net>
Cc: Glen Parker <glenebob@nwlink.com>, Postgres general mailing list <pgsql-general@postgresql.org>
Date: 2006-12-19T21:57:13Z
Lists: pgsql-hackers
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?"

-- 
erik jones <erik@myemma.com>
software development
emma(r)