Re: High CPU Load

From: "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
To: Jérôme BENOIS <benois(at)argia-engineering(dot)fr>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: High CPU Load
Date: 2006-09-14 13:46:32
Message-ID: 1d4e0c10609140646g6ad1ab4w51dec49afba11fd7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 9/14/06, Jérôme BENOIS <benois(at)argia-engineering(dot)fr> wrote:
> I migrated Postgres server from 7.4.6 to 8.1.4, But my server is
> completely full, by moment load average > 40
> All queries analyzed by EXPLAIN, all indexes are used .. IO is good ...

What is the bottleneck? Are you CPU bound? Do you have iowait? Do you
swap? Any weird things in vmstat output?

> My configuration is correct ?
> work_mem = 65536

If you have a lot of concurrent queries, it's probably far too much.
That said, if you don't swap, it's probably not the problem.

--
Guillaume

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jérôme BENOIS 2006-09-14 14:00:13 Re: High CPU Load
Previous Message Jérôme BENOIS 2006-09-14 13:08:59 High CPU Load