Re: Autovacuum Improvements

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(at)myemma(dot)com>
software development
emma(r)