Skip site navigation (1) Skip section navigation (2)

Re: problem with select count(*) ..

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: problem with select count(*) ..
Date: 2003-11-19 15:49:59
Message-ID: 20031119154959.GA18327@wolff.to (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, Nov 20, 2003 at 07:07:30 +0530,
  Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> wrote:
> 
> If i dump and reload the performance improves and it takes < 1 sec. This
> is what i have been doing since the upgrade. But its not a solution.
> 
> The Vacuum full is at the end of a loading batch SQL file which makes lot of
> insert , deletes and updates.

If a dump and reload fixes your problem, most likely you have a lot of
dead tuples in the table. You might need to run vacuum more often.
You might have an open transaction that is preventing vacuum full
from cleaning up the table.

In response to

pgsql-performance by date

Next:From: Josh BerkusDate: 2003-11-19 16:00:11
Subject: Re: More detail on settings for pgavd?
Previous:From: Shridhar DaithankarDate: 2003-11-19 14:10:46
Subject: Re: More detail on settings for pgavd?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group