Re: Autovacuum ideas

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>   This is one thing that is preventing me from turning on autovacuun,.
> However, due to the activity on them, they really need to be vacuumed
> daily.  It would be nice to be able to tell autovacuum to run, but
> have a way to tell it to always sleep during these hours ( i.e. 7am to
> 5pm daily).  Has there been any thought into a feature like this?

Well... just turn off autovac and then use vacuumdb during off hours via
cron.

Joshua D. Drake

> 
> Thanks,
> 
> Chris
-- 

            === The PostgreSQL Company: Command Prompt, Inc. ===
      Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
      Providing the most comprehensive  PostgreSQL solutions since 1997
                     http://www.commandprompt.com/






[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux