From: David Boreham <david_list@boreham.org>
To: pgsql-performance@postgresql.org
Subject: Re: scaling up postgres
Date: Sat, 03 Jun 2006 06:43:24 -0600
Message-ID: <448183EC.3030109@boreham.org> (raw)
In-Reply-To: <200606030931.k539V38Y007877@smtp2.planet.net.tn>
References: <200606030931.k539V38Y007877@smtp2.planet.net.tn>
>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).
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: david_list@boreham.org
Subject: Re: scaling up postgres
In-Reply-To: <448183EC.3030109@boreham.org>
* 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