Re: Urgent: 10K or more connections

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