X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B0A98D1B8B7 for ; Tue, 2 Mar 2004 17:50:42 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 74101-01 for ; Tue, 2 Mar 2004 13:50:37 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id D1194D1B470 for ; Tue, 2 Mar 2004 13:50:36 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i22Hoa1Y047536 for ; Tue, 2 Mar 2004 17:50:36 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i22Hg23I045002 for pgsql-performance@postgresql.org; Tue, 2 Mar 2004 17:42:02 GMT From: William Yu X-Newsgroups: comp.databases.postgresql.performance Subject: Re: Scaling further up Date: Tue, 02 Mar 2004 09:42:03 -0800 Organization: Hub.Org Networking Services Lines: 10 Message-ID: References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78509802F@vt-pe2550-001.vantage.vantage.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en In-Reply-To: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78509802F@vt-pe2550-001.vantage.vantage.com> To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/17 X-Sequence-Number: 5873 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.