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.
