From: | Ericson Smith <eric(at)did-it(dot)com> |
---|---|
To: | Geraldo Lopes de Souza <geraldol(at)uai(dot)com(dot)br> |
Cc: | Postgresql General Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Postgresql can handle 200 connections (two tier) ? |
Date: | 2002-06-26 14:45:11 |
Message-ID: | 1025102711.1449.8.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
We have well over 200 simultaneous connections in a two tier atmosphere.
We run a web cluster with well tuned apache servers (KeepAlive off), and
use transactions on every request.
Each request can have up to ~16 queries. Those ~16 queries are wrapped
in transactions with appropriate rollbacks if the thing fails. We have
tons of logging and those ~16 queries all together take about .05
seconds. We also have table sizes in the millions of tuples. About a
third of the queries are updates or inserts. Some queries are 5 table
joins as well. We have over a million transactions (~16 million queries)
every day.
On the other hand, we throw some hardware at this also :-)
4GB Ram
Dual Athlon MP 1600+
RAID Drives
Other settings:
Max-Files: 300,000
Shared Ram: 1.6GB
OS: RedHat 7.3
- Ericson Smith
eric(at)did-it(dot)com
On Tue, 2002-06-25 at 20:34, Geraldo Lopes de Souza wrote:
> Hi,
>
> I want to know if are there real world cases of postgresql supporting 200
> simultaneous connections in two tier application.
>
> I'm asking because I'm considering postgresql for the next application I
> need to write.
>
> A bit off-topic but I want to hear opinion of developers about two-tier
> versus tree-tier applications with this number of connections to a
> postgresql database.
>
> Thanks in advance
>
> Geraldo Lopes de Souza
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Curt Sampson | 2002-06-26 14:51:35 | Re: Still problems with memory swapping and server load |
Previous Message | Jan Wieck | 2002-06-26 14:44:57 | (A) native Windows port |