From owner-freebsd-performance@FreeBSD.ORG Thu Sep 13 23:44:51 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 C565416A418 for ; Thu, 13 Sep 2007 23:44:51 +0000 (UTC) (envelope-from lists@stringsutils.com) Received: from zoraida.natserv.net (p65-147.acedsl.com [66.114.65.147]) by mx1.freebsd.org (Postfix) with ESMTP id 8DD3813C457 for ; Thu, 13 Sep 2007 23:44:51 +0000 (UTC) (envelope-from lists@stringsutils.com) Received: from 35st.simplicato.com (static-71-249-233-130.nycmny.east.verizon.net [71.249.233.130]) by zoraida.natserv.net (Postfix) with ESMTP id BE19B17036; Thu, 13 Sep 2007 19:46:19 -0400 (EDT) References: <1F219879A7E5C565C96109FF@c-2f56e155.1521-1-64736c12.cust.bredbandsbolaget.se> Message-ID: X-Mailer: http://www.courier-mta.org/cone/ From: Francisco Reyes To: Palle Girgensohn Date: Thu, 13 Sep 2007 19:44:50 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="US-ASCII" Content-Disposition: inline Content-Transfer-Encoding: 7bit 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 23:44:51 -0000 Palle Girgensohn writes: > Presently ~pgsql/data has a 16 GB footprint. If you can put 4GB or better in your machine you should do well. Specially since you mentioned you are mostly read with relatively small amount of writes. > The growth is rather slow, around a percent per week What controller are you getting? We have a 3ware SATA controller with RAID6 and it performs pretty well. Based on what you wrote SATA RAID should be enough for your load and usage pattern. Obviously if you can afford SCSI/SAS performance will likely be even better. However make sure you can get management program for the controller. At the very least some type of notification if the raid is degraded.