[OPEN-ILS-DEV] Scheduled vacuuming vs. auto-vacuuming

[Mike Rylander]

On Thu, Feb 18, 2010 at 1:41 PM, Brandon W. Uhlman
<brandon.uhlman at bclibrary.ca> 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:  miker at esilibrary.com
 | web:  http://www.esilibrary.com