Re: Postgres's Performance degrades after heavy db operation - Mailing list pgsql-general

Vick Khera <vivek@khera.org> writes:
> On Mon, Jun 8, 2009 at 9:38 AM, Preeti
> Khurana<preeti.khurana@globallogic.com> wrote:
>> Any ideas/pointers on what could be making the DB slow after all these heavy
>> operations being performed?

> It seems autovacuum is not running often enough.

8.1's autovacuum isn't very aggressive by default.  You might want to
play around with its parameters.

            regards, tom lane