Message-ID: <448183EC.3030109@boreham.org>
Date: Sat, 03 Jun 2006 06:43:24 -0600
From: David Boreham <david_list@boreham.org>
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: scaling up postgres
References: <200606030931.k539V38Y007877@smtp2.planet.net.tn>
In-Reply-To: <200606030931.k539V38Y007877@smtp2.planet.net.tn>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


>I cannot scale beyond that value and the funny thing, is that none of the 
>servers is swapping, or heavy loaded, neither postgres nor apache are
>refusing connexions.
>  
>
Hearing a story like this (throughput hits a hard limit, but
hardware doesn't appear to be 100% utilized), I'd suspect
insufficient concurrency to account for the network latency
between the two servers.

Also check that your disks aren't saturating somewhere (with
iostat or something similar).

You could run pstack against both processes and see what they're
doing while the system is under load. That might give a clue
(e.g. you might see the apache processs waiting on
a response from PG, and the PG processes waiting
on a new query to process).

Since you've proved that your test client and apache can
handle a much higher throughput, the problem must lie
somewhere else (in posgresql or the interface between
the web server and postgresql).