Re: Setting up a database for 10000 concurrent users

At 09:45 PM 9/5/2005 +0100, Richard Huxton wrote:

>Poul Møller Hansen wrote:
>>I'm trying to setup a database for 10000 concurrent users for a test.
>>I have a system with 1GB of RAM where I will use 512MB for PostgreSQL.
>>It is running SuSE 9.3
>
>I think you're being horribly optimistic if you actually want 10000
>concurrent connections, with users all doing things. Even if you only
>allow 1MB for each connection that's 10GB of RAM you'd want. Plus a big
>chunk more to actually cache your database files and do work in. Then, if
>you had 10,000 concurrent queries you'd probably want a mainframe to
>handle all the concurrency, or perhaps a 64-CPU box would suffice...

10GB of RAM isn't that farfetched nowadays.

However I/O might be a problem. A single drive can typically write/read
about 10MB a second (64KB chunks random access - not sure if you'd want to
bet on getting sequential throughput ;) ).

Anyway, it'll be something interesting to see ;).

Link.