Re: scaling up postgres

Hi, Fzied,

fzied(at)planet(dot)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