Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id C5C7B64FD2B
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri, 12 Dec 2008 06:07:27 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 25427-07
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri, 12 Dec 2008 06:07:21 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from a.mail.sonomait.com (a.mail.sonomait.com [64.142.123.30])
	by mail.postgresql.org (Postfix) with ESMTP id BC3D864FCF9
	for <pgsql-performance@postgresql.org>;
	Fri, 12 Dec 2008 06:07:20 -0400 (AST)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by a.mail.sonomait.com (Postfix) with ESMTP id BD108164760
	for <pgsql-performance@postgresql.org>;
	Fri, 12 Dec 2008 02:07:15 -0800 (PST)
X-Virus-Scanned: amavisd-new at 
Received: from a.mail.sonomait.com ([127.0.0.1])
	by localhost (a.mail.sonomait.com [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 8s3WC94JTxie for <pgsql-performance@postgresql.org>;
	Fri, 12 Dec 2008 02:07:14 -0800 (PST)
Received: from [172.18.30.70] (89-96-142-243.ip12.fastwebnet.it
	[89.96.142.243])
	by a.mail.sonomait.com (Postfix) with ESMTP id 72C72164714
	for <pgsql-performance@postgresql.org>;
	Fri, 12 Dec 2008 02:07:13 -0800 (PST)
Message-ID: <494237CC.8020001@gmail.com>
Date: Fri, 12 Dec 2008 11:07:08 +0100
From: Stefano Nichele <stefano.nichele@gmail.com>
User-Agent: Thunderbird 2.0.0.18 (Windows/20081105)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: db server load
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200812/140
X-Sequence-Number: 32176

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