On Tue, Jul 24, 2012 at 5:43 PM, Anthony Bull <antsbull@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.
