| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2003-11-19 16:00:11 | Re: More detail on settings for pgavd? |
| Previous Message | Shridhar Daithankar | 2003-11-19 14:10:46 | Re: More detail on settings for pgavd? |