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

From Poul Møller Hansen
Subject Re: Setting up a database for 10000 concurrent users
Date
Msg-id 431DF51C.1070605@pbnet.dk
Whole thread Raw
In response to Re: Setting up a database for 10000 concurrent users  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
Responses Re: Setting up a database for 10000 concurrent users
List 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

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: PostgreSQL and XML support
Next
From: Alvaro Herrera
Date:
Subject: Re: Shared disk storage