> Does the current implementation of pg_autovacuum have a way of setting
> windows where it is allowed to vacuum? Many large 24/7 will only allow
> vacuumming at certain times of the day.
No the current implementation doesn't, but such a feature is in the works
(planned anyway). What I was envisioning is the ability to set two
different sets of thresholds (peak / off peak). If you demand zero
vacuuming during peak times, you could set that threshold to -1, or some
such setting.
FYI I wouldn't remcommend defaulting pg_autovacuum to on until it does
this, and a few more things that are also planned (see the archives).
Matthew