On Tue, Jul 24, 2012 at 5:43 PM, Anthony Bull <antsb...@gmail.com> wrote: > We found the auto vacuum would always kick in during our daily data loads in > the mornings and completely bottle neck our system, and in the end had to > turn it off and schedule our own vacuum analyze over the weekend each week > using crontab. We do a couple of gigs of inserts a week into our postgres > db - and having control of when vacuuming happens is pretty important, as > our system is online 24 hours to both northern and southern hemispheres.
Please note that autovacuum is tunable in terms of how much load it places on a system when it runs. Often making it somewhat less aggressive can accomplish the same task as scheduling regular vacuums. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
