From: Matthew Lunnon <mlunnon@rwa-net.co.uk>
To: pgsql-performance@postgresql.org
Subject: Limited performance on multi core server
Date: Wed, 12 Dec 2007 10:16:43 +0000
Message-ID: <475FB50B.8060701@rwa-net.co.uk> (raw)
Hi,
I have a 4 * dual core 64bit AMD OPTERON server with 16G of RAM, running
postgres 7.4.3. This has been recompiled on the server for 64 stored
procedure parameters, (I assume this makes postgres 64 bit but are not
sure). When the server gets under load from database connections
executing reads, lets say 20 - 40 concurrent reads, the CPU's seem to
limit at about 30-35% usage with no iowait reported. If I run a simple
select at this time it takes 5 seconds, the same query runs in 300
millis when the server is not under load so it seems that the database
is not performing well even though there is plenty of spare CPU. There
does not appear to be large amounts of disk IO and my database is about
5.5G so this should fit comfortably in RAM.
changes to postgresql.sql:
max_connections = 500
shared_buffers = 96000
sort_mem = 10240
effective_cache_size = 1000000
Does anyone have any ideas what my bottle neck might be and what I can
do about it?
Thanks for any help.
Matthew.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mlunnon@rwa-net.co.uk
Subject: Re: Limited performance on multi core server
In-Reply-To: <475FB50B.8060701@rwa-net.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox