On Tue, Feb 7, 2012 at 2:43 PM, Ofer Israeli <of...@checkpoint.com> wrote: > You mean running a VACUUM statement manually? I would basically try to avoid > such a situation as the way I see it, the database should be configured in > such a manner that it will be able to handle the load at any given moment and > so I wouldn't want to manually intervene here. If you think differently, > I'll be happy to stand corrected.
I do think differently. Autovacuum isn't perfect, and you shouldn't make it too aggressive since it does generate a lot of I/O activity. If you can pick a time where it will be able to run without interfering too much, running vacuum "manually" (where manually could easily be a cron task, ie, automatically but coming from outside the database software itself), you'll be able to dial down autovacuum and have more predictable load overall. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
