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 051AF5E46E3 for ; Wed, 18 Aug 2004 13:12:22 -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 40701-10 for ; Wed, 18 Aug 2004 16:12:26 +0000 (GMT) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id 03D365E46DE for ; Wed, 18 Aug 2004 13:12:18 -0300 (ADT) Received: from [134.22.71.19] (dyn-71-19.tor.dsl.tht.net [134.22.71.19]) by tht.net (Postfix) with ESMTP id D0A4F76A14; Wed, 18 Aug 2004 12:12:27 -0400 (EDT) Subject: Re: Help specifying new machine From: Rod Taylor To: Raoul Buzziol Cc: Postgresql Performance In-Reply-To: References: <20040809165657.GB15169@campbell-lange.net> Content-Type: text/plain Message-Id: <1092845543.32799.145.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Wed, 18 Aug 2004 12:12:23 -0400 Content-Transfer-Encoding: 7bit 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/275 X-Sequence-Number: 7911 On Wed, 2004-08-18 at 11:18, Raoul Buzziol wrote: > > You're not going to be able to get a Dual Athlon MP for the same price > > as a single Xeon. A few years back, this was the case because Xeon CPUs > > & MBs had a huge premium over Athlon. This is no longer true mainly > > because the number of people carrying Athlon MP motherboards has dropped > > down drastically. Go to pricewatch.com and do a search for 760MPX -- you > > get a mere 8 entries. Not surprisingly because who would not want to > > spend a few pennies more for a much superior Dual Opteron? The few > > sellers you see now just keep stuff in inventory for people who need > > replacement parts for emergencies and are willing to pay up the nose > > because it is an emergency. > > I saw pricewatch.com and you're right. > > 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. For PostgreSQL, Opteron might be a touch worse than Xeon for single processor, little better for Dual, and a whole heck of a bunch better for Quads -- but this depends on your specific work load as memory bound, cpu bound, lots of float math, etc. work loads will perform differently. In general, an Opteron is a better bet simply because you can shove more ram onto it (without workarounds), and you can't beat an extra 8GB ram on an IO bound database (consider your datasize in 1 year).