Re: Scaling further up - Mailing list pgsql-performance

From William Yu
Subject Re: Scaling further up
Date
Msg-id c22h19$1bod$1@news.hub.org
Whole thread Raw
In response to Scaling further up  ("Anjan Dave" <adave@vantage.com>)
Responses Re: Scaling further up
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Select-Insert-Query
Next
From: Fred Moyer
Date:
Subject: Re: Scaling further up