Re: Postgres's Performance degrades after heavy db operation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vick Khera <vivek(at)khera(dot)org>
Cc: Preeti Khurana <preeti(dot)khurana(at)globallogic(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres's Performance degrades after heavy db operation
Date: 2009-06-08 17:52:27
Message-ID: 580.1244483547@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Vick Khera <vivek(at)khera(dot)org> writes:
> On Mon, Jun 8, 2009 at 9:38 AM, Preeti
> Khurana<preeti(dot)khurana(at)globallogic(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2009-06-08 17:57:47 Re: 'cost' and 'rows' for volitile function
Previous Message Bill Moran 2009-06-08 17:51:10 Re: Duplicate key issue in a transaction block