Postgres Pro
Downloads
Home   >   mailing lists

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

From Vick Khera
Subject Re: Postgres's Performance degrades after heavy db operation
Date
Msg-id 2968dfd60906080925r42c1a3ddk8728c4a653a1afb6@mail.gmail.com
Whole thread Raw
In response to Postgres's Performance degrades after heavy db operation  ("Preeti Khurana" <preeti.khurana@globallogic.com>)
Responses Re: Postgres's Performance degrades after heavy db operation
List pgsql-general
Tree view 
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.  You may wish to
include vacuum in your data update/delete programs so that it runs
after some number of those operations.

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Postgres's Performance degrades after heavy db operation
Next
From: Bill Moran
Date:
Subject: Re: Duplicate key issue in a transaction block