Re: Setting up a database for 10000 concurrent users
От | Lincoln Yeoh |
---|---|
Тема | Re: Setting up a database for 10000 concurrent users |
Дата | |
Msg-id | 5.2.1.1.1.20050907004102.04c718a8@localhost обсуждение исходный текст |
Ответ на | Re: Setting up a database for 10000 concurrent users (Richard Huxton <dev@archonet.com>) |
Ответы |
Re: Setting up a database for 10000 concurrent users
|
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: