Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group