From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Francois Suter <dba(at)paragraf(dot)ch> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Urgent: 10K or more connections |
Date: | 2003-07-18 15:53:28 |
Message-ID: | Pine.LNX.4.33.0307180951510.1889-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On Fri, 18 Jul 2003, Francois Suter wrote:
> 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.
>
> Do you have any additional advice I could transmit to this person about
> handling that many connections. I'm sure any help we can provide will be an
> additional selling point.
Wow! That's quite a few connections. I would say that 10,000 connections
is a lot for ANY database to hold open.
Can this person use connection pooling? Or do they need an actual 10,000
parallel accesses to get things done? If they can't use connection
pooling, or connection pooling only gets them down to 10k to 40k
connections, then that's a huge system. I wouldn't run something that big
on Oracle or Postgresql, I'd use a farm of mainframes running something
like TPF like the airlines do.
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2003-07-18 15:59:58 | Re: FATAL 2: open of /var/lib/pgsql/data/pg_clog/0EE3 |
Previous Message | Dmitry Tkach | 2003-07-18 15:50:29 | FATAL 2: open of /var/lib/pgsql/data/pg_clog/0EE3 failed: No such file or directory |
From | Date | Subject | |
---|---|---|---|
Next Message | Doug McNaught | 2003-07-18 16:06:50 | Re: Urgent: 10K or more connections |
Previous Message | Reinoud van Leeuwen | 2003-07-18 15:24:52 | plpgsql strangeness with select into <variable> |