Re: High CPU Load

["Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>]

On 9/18/06, Jérôme BENOIS <benois(at)argia-engineering(dot)fr> wrote:
>         Tomorrow morning i plan to add 2Go RAM in order to test difference with
> my actual config.

I don't think more RAM will change anything if you don't swap at all.
You can try to set shared_buffers lower (try 32768 and 16384) but I
don't think it will change anything in 8.1.

The only thing left IMHO is that 8.1 is choosing a bad plan which
consumes a lot of CPU for at least a query.

When you analyze your logs, did you see a particularly slow query? Can
you compare query log analysis from your old server and your new one?

--
Guillaume