X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 5BBDED1B8C6 for ; Fri, 29 Aug 2003 07:22:42 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 98536-04 for ; Fri, 29 Aug 2003 04:22:33 -0300 (ADT) Received: from news.hub.org (unknown [64.117.224.194]) by svr1.postgresql.org (Postfix) with ESMTP id B3D98D1B8BB for ; Fri, 29 Aug 2003 04:22:29 -0300 (ADT) Received: from news.hub.org (host-64-117-224-194.altec1.com [64.117.224.194] (may be forged)) by news.hub.org (8.12.9/8.12.9) with ESMTP id h7T7MTek027656 for ; Fri, 29 Aug 2003 07:22:29 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id h7T754PK024600 for pgsql-performance@postgresql.org; Fri, 29 Aug 2003 07:05:04 GMT From: William Yu X-Newsgroups: comp.databases.postgresql.performance Subject: Re: Hardware recommendations to scale to silly load Date: Fri, 29 Aug 2003 00:05:03 -0700 Organization: Hub.Org Networking Services Lines: 27 Message-ID: References: <1061953146.18108.291.camel@haggis> <3F4E5DA9.6396.5C8916@localhost> 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.4) Gecko/20030624 X-Accept-Language: en-us, en In-Reply-To: <3F4E5DA9.6396.5C8916@localhost> To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/473 X-Sequence-Number: 3289 Shridhar Daithankar wrote: >> Be careful here, we've seen that with the P4 Xeon's that are >>hyper-threaded and a system that has very high disk I/O causes the >>system to be sluggish and slow. But after disabling the hyper-threading >>itself, our system flew.. > > Anybody has opteron working? Hows' the performance? Yes. I'm using an 2x 1.8GHz Opteron system w/ 8GB of RAM. Right now, I'm still using 32-bit Linux -- I'm letting others be the 64-bit guinea pigs. :) I probably will get a cheapie 1x Opteron machine first and test the 64-bit kernel/libraries thoroughly before rolling it out to production. As for performance, the scaling is magnificient -- even when just using PAE instead of 64-bit addressing. At low transaction counts, it's only ~75% faster than the 2x Athlon 1800+ MP it replaced. But once the transactions start coming in, the gap is as high as 5x. My w-a-g: since each CPU has an integrated memory controller, you avoid memory bus contention which is probably the major bottleneck as transaction load increases. (I've seen Opteron several vs Xeon comparisons where single-connection tests are par for both CPUs but heavy-load tests favor the Opteron by a wide margin.) I suspect the 4X comparisons would tilt even more towards AMD's favor. We should see a boost when we move to 64-bit Linux and hopefully another one when NUMA for Linux is production-stable.