Re: scaling up postgres

From: David Boreham <david_list(at)boreham(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: scaling up postgres
Date: 2006-06-03 12:43:24
Message-ID: 448183EC.3030109@boreham.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-06-03 15:12:38 Re: scaling up postgres
Previous Message Steinar H. Gunderson 2006-06-03 10:52:23 Re: Répondre