Francois Suter <dba@paragraf.ch> writes:
> Hi all,
>
> I have received a question via the Advocacy site and I am not knowledgeable
> enough to answer. Can you help?
>
> The question is: can PostgreSQL handle between 10'000 and 40'000
> simultaneous connections? The persone asking the question has to choose
> between Oracle and PostgreSQL, and my guess is that they would be relieved
> if they could go with PostgreSQL.
On a big enough system, sure. Each PG connection backend is a
separate process, so you'd need to make sure the process table was big
enough, open file and shared memory limits set high, etc. You'd want
a really big machine, hopefully 64-bit like a Sparc or IA64, with lots
of memory. But you'd want that for Oracle, too.
You'd definitely want to spend a lot of time tuning and testing for
that activity level, but again, you'd do that for Oracle too.
-Doug