db server load

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-performance by date

  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