On Thu, Feb 18, 2010 at 1:41 PM, Brandon W. Uhlman <[email protected]> wrote: > Hi, all. > > Is there a best practice on production Evergreen systems in choosing between > scheduled vacuums of the PostgreSQL database vs. having auto-vacuum enabled? >
It's situation dependent. If you put time into finding the right autovac params (per table, for 8.3+ IIRC) then that's a less brute-force solution. But if you find spikes of high IO during the day while autovac is doing its thing, then a nightly or weekly cron'd vacuum may be better. -- Mike Rylander | VP, Research and Design | Equinox Software, Inc. / The Evergreen Experts | phone: 1-877-OPEN-ILS (673-6457) | email: [email protected] | web: http://www.esilibrary.com
