Re: Autovacuum Improvements

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.