Scaling further up - Mailing list pgsql-performance

From Anjan Dave
Subject Scaling further up
Date
Msg-id 4BAFBB6B9CC46F41B2AD7D9F4BBAF78509802F@vt-pe2550-001.vantage.vantage.com
Whole thread Raw
Responses Re: Scaling further up  (William Yu <wyu@talisys.com>)
List pgsql-performance
All:
 
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.
 
What is the next step up in terms of  handling very heavy loads? Clustering?
 
Are there any standard, recommended clustering options?
 
 
Also, in terms of hardware, overall, what benefits more, a SunFire 880 (6 or 8 CPUs, lots of RAM, internal FC Drives) type of machine, or an IA-64 architecture?
 
Appreciate any inputs,
 
Thanks,
Anjan

**************************************************************************

This e-mail and any files transmitted with it are intended for the use of the addressee(s) only and may be confidential and covered by the attorney/client and other privileges. If you received this e-mail in error, please notify the sender; do not disclose, copy, distribute, or take any action in reliance on the contents of this information; and delete it from your system. Any other use of this e-mail is prohibited.

 

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: compiling 7.4.1 on Solaris 9
Next
From: "scott.marlowe"
Date:
Subject: Re: Slow query