From: Markus Schaber <schabi@logix-tt.com>
To: fzied@planet.tn
Cc: pgsql-performance@postgresql.org
Subject: Re: scaling up postgres
Date: Wed, 21 Jun 2006 09:26:05 +0200
Message-ID: <4498F48D.2070305@logix-tt.com> (raw)
In-Reply-To: <200606030931.k539V38Y007877@smtp2.planet.net.tn>
References: <200606030931.k539V38Y007877@smtp2.planet.net.tn>
Hi, Fzied,
fzied@planet.tn wrote:
> I'm using httperf/autobench for measurments and the best result I can
> get is that my system can handle a trafiic of almost 1600 New
> con/sec.
Are you using connection pooling or persistent connections between
PostgreSQL and the Apaches?
Maybe it simply is the network latency between the two machines - as the
database is read-only, did you think about having both PostgreSQL and
Apache on both machines, and then load-balancing ingoing http requests
between them?
> 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.
And for measuring, are you really throwing parallel http connections to
the server? This sounds like you measure request latency, but the
maximum throughput might be much higher.
> my database is only 58M it's a read only DB and will lasts only for a
> month.
I guess it is a simple table with a single PK (some subscription numer)
- no joins or other things.
For this cases, a special non-RDBMS like MySQL, SQLite, or even some
hancrafted thingy may give you better results.
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
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: schabi@logix-tt.com, fzied@planet.tn
Subject: Re: scaling up postgres
In-Reply-To: <4498F48D.2070305@logix-tt.com>
* 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