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

High CPU Load

From: Jérôme BENOIS <benois(at)argia-engineering(dot)fr>
To: pgsql-performance(at)postgresql(dot)org
Subject: High CPU Load
Date: 2006-09-14 13:08:59
Message-ID: 1158239339.5226.17.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-performance
Hi All,

   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 ...

My configuration is correct ?

- default configuration and se + somes updates : 

max_connections = 512
superuser_reserved_connections = 2
shared_buffers = 65536
work_mem = 65536
effective_cache_size = 131072
log_destination = 'syslog'
redirect_stderr = off
log_directory = '/var/log/pgsql'
log_min_duration_statement = 100
silent_mode = on
log_statement = 'none'
default_with_oids = on

My Server is Dual Xeon 3.06GHz with 2 Go RAM and good SCSI disks.

Best Regards,
Jérôme BENOIS.

Responses

pgsql-performance by date

Next:From: Guillaume SmetDate: 2006-09-14 13:46:32
Subject: Re: High CPU Load
Previous:From: Dave CramerDate: 2006-09-14 11:33:34
Subject: Re: sql-bench

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