From owner-freebsd-performance@FreeBSD.ORG Thu Sep 13 20:45:20 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 1724416A46C for ; Thu, 13 Sep 2007 20:45:20 +0000 (UTC) (envelope-from girgen@pingpong.net) Received: from proxy2.bredband.net (proxy2.bredband.net [195.54.101.72]) by mx1.freebsd.org (Postfix) with ESMTP id C1DA713C465 for ; Thu, 13 Sep 2007 20:45:19 +0000 (UTC) (envelope-from girgen@pingpong.net) Received: from c-2f56e155.1521-1-64736c12.cust.bredbandsbolaget.se (85.225.86.47) by proxy2.bredband.net (7.3.127) id 46E932370002108D; Thu, 13 Sep 2007 22:24:38 +0200 Date: Thu, 13 Sep 2007 22:24:38 +0200 From: Palle Girgensohn To: Francisco Reyes Message-ID: <1F219879A7E5C565C96109FF@c-2f56e155.1521-1-64736c12.cust.bredbandsbolaget.se> In-Reply-To: References: X-Mailer: Mulberry/4.0.6 (Mac OS X) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Cc: freebsd-performance@freebsd.org 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, 13 Sep 2007 20:45:20 -0000 --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... > Personally I think having lots of memory and a good disk subsystem is > going to make a bigger difference. true > What sizes are you expecting for your data? > What type of growth? How many concurrent connections? Presently ~pgsql/data has a 16 GB footprint. The growth is rather slow, around a percent per week, sometimes much more due to batch updates. Even with a high system load, we seldom see more than a 30-40 concurrent postgresql connections. /Palle