Hi, Fzied, fzied@xxxxxxxxx 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
