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)