X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2B33D5E46F5 for ; Thu, 19 Aug 2004 01:42:43 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79598-06 for ; Thu, 19 Aug 2004 04:42:49 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id F27BC5E46CC for ; Thu, 19 Aug 2004 01:42:32 -0300 (ADT) 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 i7J4gmiG080188 for ; Thu, 19 Aug 2004 04:42:48 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i7J4QrmM076509 for pgsql-performance@postgresql.org; Thu, 19 Aug 2004 04:26:53 GMT From: William Yu X-Newsgroups: comp.databases.postgresql.performance Subject: Re: Help specifying new machine Date: Wed, 18 Aug 2004 21:26:45 -0700 Organization: Hub.Org Networking Services Lines: 25 Message-ID: References: <20040809165657.GB15169@campbell-lange.net> 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.7b) Gecko/20040421 X-Accept-Language: en-us, en In-Reply-To: To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/284 X-Sequence-Number: 7920 Raoul Buzziol wrote: > I looked for some benchmarks, and I would know if I'm right on: > - Dual Opteron 246 have aproximately the same performance of a Dual Xeon 3Gh > (Opteron a little better) > - Opteron system equal or cheeper than Xeon system. In terms of general database performance, top of the line dual opteron will perform roughly the same as top of the line dual xeon. Assuming you just run in 32-bit mode. Throw in 64-bit mode, NUMA, etc, all bets are off. In terms of Postgres database performance, Opteron *may* be the better CPU for this app but there's not enough data points yet. Here's a recent review at Anandtech showing Opteron 150 (2.4ghz) versus 64-bit Prescott 3.6hgz with some very simple MySQL and Postgres benchmarks: http://www.anandtech.com/linux/showdoc.aspx?i=2163&p=2 What is a slight lead in MySQL becomes a blowout in Postgres. Of course, this is just the 1MB cache model. I'm sure if you went with the 2MB or 4MB models, the Xeons would come up much closer. The really good sign in the above numbers though is that somebody finally included Postgres in their benchmark suite. :) We may be seeing more and more data points to evaluate hardware for Postgres in the near future.