> 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. Regards, Richard Broersma Jr. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
