Re: Postgres's Performance degrades after heavy db operation

From: Vick Khera <vivek(at)khera(dot)org>
To: Preeti Khurana <preeti(dot)khurana(at)globallogic(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres's Performance degrades after heavy db operation
Date: 2009-06-08 16:25:08
Message-ID: 2968dfd60906080925r42c1a3ddk8728c4a653a1afb6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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. You may wish to
include vacuum in your data update/delete programs so that it runs
after some number of those operations.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2009-06-08 16:26:05 'cost' and 'rows' for volitile function
Previous Message Vick Khera 2009-06-08 16:23:38 Re: Entering time into postgresql