Re: Setting up a database for 10000 concurrent users

"Sergey E. Koposov" <math(at)sai(dot)msu(dot)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