Re: Setting up a database for 10000 concurrent users - Mailing list pgsql-general

From Tom Lane
Subject Re: Setting up a database for 10000 concurrent users
Date
Msg-id 13232.1125969288@sss.pgh.pa.us
Whole thread Raw
In response to Re: Setting up a database for 10000 concurrent users  ("Sergey E. Koposov" <math@sai.msu.ru>)
List pgsql-general
"Sergey E. Koposov" <math@sai.msu.ru> writes:
> But I really doubt that it it possible/reasonable to have 10000
> simultaneous connections.

You're going to need a heck of a beefy machine to do it, anyway.

I would expect that after fixing the semaphore configuration problem,
the next thing that'll be an issue is the size of the kernel's open
files table.  Do you have the kernel configured to support several
hundred thousand open files?

Also, as already noted, you need to figure at least a megabyte or two
of working storage per connection, so even if it runs it'll probably
swap like mad.

Put a connection pooler in front, instead...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug or ?
Next
From: Leonard Soetedjo
Date:
Subject: PostgreSQL local replication