Re: Autovacuum Improvements - Mailing list pgsql-general

From Erik Jones
Subject Re: Autovacuum Improvements
Date
Msg-id 45886039.7020400@myemma.com
Whole thread Raw
In response to Re: Autovacuum Improvements  (Matthew O'Connor <matthew@zeut.net>)
Responses Re: Autovacuum Improvements  (Glen Parker <glenebob@nwlink.com>)
List pgsql-general
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)


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: admin82.sql
Next
From: Glen Parker
Date:
Subject: Re: Autovacuum Improvements