Re: Autovacuum Improvements

Glen Parker wrote:
>> I wonder if the simple solution is to just have a cron script modify
>> postgresql.conf and pg_ctl reload.  That seems very flexible, or have
>> two postgresql.conf files and move them into place via cron.
>
> I'd still prefer to vacuum on demand actually.  Rather than hope that
> autovacuum hit all the nastiest tables, I'd like to be able to record
> the fact that tables (x,y,z) were vacuumed and how long it took.  I want
> the logic autovacuum uses to determine if a table needs vacuuming, but
> I'd rather do the actual vacuuming myself.
>
> I'd also like to use some of this information to issue reindex and
> cluster commands only when they're needed.  In fact, on days when I
> cluster, there's no need whatsoever to also vacuum those tables.  This
> is something that autovacuum won't do at all.
>
> If the best I got was access to the same information autovacuum uses to
> make its decisions, I'd be pretty happy

Well take a look at the autovacuum code, also, before autovacuum was
integrated into core it existed as a libpq based contrib application so
you can look in one of the older branches for that code.