Glen Parker wrote:
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?"...
I understand that, but it's a subjective question. The only question
autovacuum answers is "Am I going to vacuum this table now?", so in the
current setup you probably could create a function that answers your
question, I was just pointing out in the future when maintenance windows
get implemented that this question becomes less clear.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
