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: | Raw Message | Whole Thread | 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? |