| From: | Reynard Hilman <reynardmh(at)lightsky(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | handling 20,000 connection? |
| Date: | 2002-10-31 14:39:02 |
| Message-ID: | 3DC14086.7040503@lightsky.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fernando Nasser | 2002-10-31 14:44:50 | Re: Can't start rhdb-admin |
| Previous Message | Nigel J. Andrews | 2002-10-31 14:10:25 | Re: CREATE TABLE oddity? |