Reynard-
I can't be of much help in answering the upper limit question, but I wonder
if that is really the right question.
Do you really expect all 20,000 users to be accessing the database at the
same time, or is it more like 20,000 users in the application at one time.
Usually, such a situation is handled by connection pooling so that although
many users are connected to the application, they only get allocated a db
connection as needed. The ratio will vary by application, but in our case,
we can typically support at least 20 active users per connection using
pooling.
-Nick
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Reynard Hilman
> Sent: Thursday, October 31, 2002 9:39 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] handling 20,000 connection?
>
>
>
> Hi,
>
> I need to set up a system that will be used by some 20,000 users. Most
> of the applications will be web based.
> I'm wondering if postgress will be able to handle 20,000 connection.
> MySQL has a max connection of about 16,000. Does postgres have a max
> connection limit? or does the limit depend on the hardware resources only?
> I wonder if using a cluster will help (something like oracle database
> cluster). I have search the mailing list for clustering, and found some
> articles
>
> http://archives.postgresql.org/pgsql-general/2000-12/msg00024.php
>
> but this was quite long time ago, and it seems like they are still in
> research.
> Has anyone done postgres clustering for a production use?
> It would be helpful to have a section explaining how to do this (if it's
> possible).
>
> thanks,
> - reynard
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>