| From: | Stefano Nichele <stefano(dot)nichele(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | db server load |
| Date: | 2008-12-12 10:07:08 |
| Message-ID: | 494237CC.8020001@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi All,
I would like to ask to you, how many connections a db server can handle.
I know the question is not so easy, and actually I don't want to known a
"number" but something like:
- up to 100 connections: small load, low entry server is enough
- up to 200 connections: the db server starts to sweat, you need a
dedicated medium server
- up to 300 connections: hard work, dedicated server
- up to 500 connections: hard work, dedicated high level server
I would like just to understand when we can talk about small/medium/high
load.
At the moment I'm using a quad-proc system with a 6 disk 1+0 RAID array
and 2 separate disks for the OS and write-ahead logs.
Thanks
ste
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2008-12-12 21:44:51 | Re: db server load |
| Previous Message | Greg Smith | 2008-12-12 07:55:52 | Re: Need help with 8.4 Performance Testing |