From: Stefano Nichele <stefano.nichele@gmail.com>
To: pgsql-performance@postgresql.org
Subject: db server load
Date: Fri, 12 Dec 2008 11:07:08 +0100
Message-ID: <494237CC.8020001@gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: stefano.nichele@gmail.com
Subject: Re: db server load
In-Reply-To: <494237CC.8020001@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox