From owner-freebsd-performance@FreeBSD.ORG Thu Sep 20 22:39:41 2007 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id ECC8516A417 for ; Thu, 20 Sep 2007 22:39:41 +0000 (UTC) (envelope-from decibel@decibel.org) Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by mx1.freebsd.org (Postfix) with ESMTP id A474F13C45A for ; Thu, 20 Sep 2007 22:39:41 +0000 (UTC) (envelope-from decibel@decibel.org) Received: from [10.224.31.73] (unknown [38.98.147.68]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) by noel.decibel.org (Postfix) with ESMTP id 5EC4F5644B; Thu, 20 Sep 2007 15:19:06 +0000 (UTC) In-Reply-To: <1F219879A7E5C565C96109FF@c-2f56e155.1521-1-64736c12.cust.bredbandsbolaget.se> References: <1F219879A7E5C565C96109FF@c-2f56e155.1521-1-64736c12.cust.bredbandsbolaget.se> Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <57EF86A6-6062-4F1A-959E-41ABABD3F0CF@decibel.org> Content-Transfer-Encoding: 7bit From: Decibel! Date: Thu, 20 Sep 2007 09:53:18 -0500 To: Palle Girgensohn X-Mailer: Apple Mail (2.752.3) Cc: freebsd-performance@freebsd.org, Francisco Reyes Subject: Re: AMD or Intel? X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 20 Sep 2007 22:39:42 -0000 On Sep 13, 2007, at 3:24 PM, Palle Girgensohn wrote: > --On torsdag, torsdag 13 sep 2007 15.07.17 -0400 Francisco Reyes > wrote: > >> Palle Girgensohn writes: >> >>> Now, I hear rumors that AMD is to be preferred over Intel for >>> performance >> >> From what I have read in the past, specially in the postgresql >> list, it >> seems the AMD64 cpus do better with Postgresql. Possibly because of >> better bus architecture. > > I think this is not current information; the new woodcrest > architecture performs mucg better, although this is deduced from > this thread's discussion... Except this thread has largely glossed over the importance of memory bandwidth, which is exactly the reason why Opterons have been beating Xeons for several years. Last I'd heard, things were fairly close between the two, but that would matter on how many cores and physical CPUs you have. It would be good if someone could do a database benchmark for some of the larger parts. Something else worth mentioning... a lot of work is being done to improve PostgreSQL scalability for larger numbers of CPUs. If you're looking at anything over 4 cores, I recommend going to 8.3 ASAP. -- Decibel!, aka Jim C. Nasby, Database Architect decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828