Re: performance problems ... 100 cpu utilization - Mailing list pgsql-performance

From Dennis
Subject Re: performance problems ... 100 cpu utilization
Date
Msg-id 42D7DE40.3070507@works4me.com
Whole thread Raw
In response to Re: performance problems ... 100 cpu utilization  (David Mitchell <david.mitchell@telogis.com>)
List 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

pgsql-performance by date:

Previous
From: Dan Harris
Date:
Subject: Re: slow joining very large table to smaller ones
Next
From: Bruno Wolff III
Date:
Subject: Re: slow joining very large table to smaller ones