Re: Setting up a database for 10000 concurrent users

From: Poul Møller Hansen <freebsd(at)pbnet(dot)dk>
To: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
Cc: Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Setting up a database for 10000 concurrent users
Date: 2005-09-06 19:59:24
Message-ID: 431DF51C.1070605@pbnet.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> 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.
>
The database server is started now with max_connections = 10000
and 100MB RAM is used

/dev/sda:
Timing buffered disk reads: 162 MB in 3.04 seconds = 53.32 MB/sec

It is not that bad :)
Yes I know there should be more disk arms.

Now I'm curious to see how the many threads will be handled in Java ...

Poul

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2005-09-06 20:03:34 Re: Shared disk storage
Previous Message Bruno Wolff III 2005-09-06 19:58:52 Re: Shared disk storage