Re: AutoVacuum on demand?

Richard Broersma Jr wrote:
> > Richard Broersma Jr wrote:
> > >> Cron yes, vacuumdb no. I would like to AUTO vacuum periodically.
> > > Just curious, what is auto_vacuum going to give that vacuumdb wont?
> > Hmm, I thought this would be obvious. Vacuumdb just issues "VACUUM"
> > commands.
> > I would like the get the functionality if autovacuum so that I don't
> > waste cycles on tables that don't really need vacuuming. However, we've
> > had bad luck letting autovacuum run on its own terms, so we've reverted
> > to the old nightly vacuums.
> > Since our nightly window of relative inactivity continues to shrink, I'd
> > like to vacuum/analyze only the tables that autovacuum thinks need it,
> > all at once, and only when I tell it to (via cron).
> > Make more sense?
>
> Yes that make sense. I don't know if this helps, but I remember
> reading a thread on one of the lists that discussed adding
> functionality to auto_vacuum to allow it to ignore specified tables.
> I can't remember if this is a newly added feature or if it is slated
> for 8.2.

It's present in 8.1. Just set "enabled" to false on pg_autovacuum for
the given table. (If there's no tuple, insert one).

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.