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.
In response to
pgsql-performance by date
|Next:||From: Jérôme BENOIS||Date: 2006-09-14 14:00:13|
|Subject: Re: High CPU Load|
|Previous:||From: Jérôme BENOIS||Date: 2006-09-14 13:08:59|
|Subject: High CPU Load|