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@xxxxxxxxxx>
software development
emma(r)