From: Fred Moyer <fred@redhotpenguin.com>
To: William Yu <wyu@talisys.com>
To: Anjan Dave <adave@vantage.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Scaling further up
Date: Tue, 02 Mar 2004 10:57:27 +0000
Message-ID: <1078225047.2707.67.camel@harpua.redhotpenguin.com> (raw)
In-Reply-To: <c22h19$1bod$1@news.hub.org>
References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78509802F@vt-pe2550-001.vantage.vantage.com>
<c22h19$1bod$1@news.hub.org>
On Tue, 2004-03-02 at 17:42, William Yu wrote:
> Anjan Dave wrote:
> > We have a Quad-Intel XEON 2.0GHz (1MB cache), 12GB memory, running RH9,
> > PG 7.4.0. There's an internal U320, 10K RPM RAID-10 setup on 4 drives.
> >
> > We are expecting a pretty high load, a few thousands of 'concurrent'
> > users executing either select, insert, update, statments.
>
> The quick and dirty method would be to upgrade to the recently announced
> 3GHz Xeon MPs with 4MB of L3. My semi-educated guess is that you'd get
> another +60% there due to the huge L3 hiding the Xeon's shared bus penalty.
If you are going to have thousands of 'concurrent' users you should
seriously consider the 2.6 kernel if you are running Linux or as an
alternative going with FreeBSD. You will need to load test your system
and become an expert on tuning Postgres to get the absolute maximum
performance from each and every query you have.
And you will need lots of hard drives. By lots I mean dozen(s) in a
raid 10 array with a good controller. Thousands of concurrent users
means hundreds or thousands of transactions per second. I've personally
seen it scale that far but in my opinion you will need a lot more hard
drives and ram than cpu.
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: fred@redhotpenguin.com, wyu@talisys.com, adave@vantage.com
Subject: Re: Scaling further up
In-Reply-To: <1078225047.2707.67.camel@harpua.redhotpenguin.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