Re: Autovacuum Improvements

[Matthew O'Connor <matthew(at)zeut(dot)net>]

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.