Re: performance problems ... 100 cpu utilization

From: Dennis <dennis(at)works4me(dot)com>
To: David Mitchell <david(dot)mitchell(at)telogis(dot)com>
Cc: Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu>, pgsql-performance(at)postgresql(dot)org
Subject: Re: performance problems ... 100 cpu utilization
Date: 2005-07-15 16:03:12
Message-ID: 42D7DE40.3070507@works4me.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

David Mitchell wrote:

> If your table has got into this state, then vacuum analyze won't fix
> it. You will have to do a vacuum full to get it back to normal, then
> regularly vacuum (not full) to keep it in good condition. We vacuum
> our critical tables every 10 minutes to keep them in good nick.

So should I have vacuum run during the load test? At what level of
updates should it run every ten minutes?

Dennis

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bruno Wolff III 2005-07-15 16:44:58 Re: slow joining very large table to smaller ones
Previous Message Dan Harris 2005-07-15 15:21:31 Re: slow joining very large table to smaller ones