Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id D61EE9FB53A for ; Thu, 5 Apr 2007 13:10:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 18311-03 for ; Thu, 5 Apr 2007 13:10:02 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.243]) by postgresql.org (Postfix) with ESMTP id 678319FB4F4 for ; Thu, 5 Apr 2007 13:10:02 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c24so733827ana for ; Thu, 05 Apr 2007 09:10:01 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ShLAuwze35TVrONPVoCooDHQvc6inqbGkdsYulPC9hWu88l7av3HIj22cvS5Lha7+RR9gJ3ea7cbk6wD1hz61oeGAZpabmy0C8fLSK8pY0WOGgXSRl8GjkSDJm/hO2Aqd22uan19tbwiM1ielLlDzsPvhvdAMD9DlXPjAeluu84= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ECdv341PAXJe54z9SgS4TOBcXmsNbZb1Si+gwgyOo7pVh3OUADkvtjxbwpsejb/sS3k0tIdCQ25Hyj78LkKWZwOGZImQLTDNQcR5I3il4yMOtFtK8hRwmJ/wxDSKiu8AO+hNE29Rg9NJLgQmQzoK2K63ciNcyWwHxQogHSVIWaw= Received: by 10.100.11.7 with SMTP id 7mr1395908ank.1175789400132; Thu, 05 Apr 2007 09:10:00 -0700 (PDT) Received: by 10.100.247.7 with HTTP; Thu, 5 Apr 2007 09:10:00 -0700 (PDT) Message-ID: Date: Thu, 5 Apr 2007 12:10:00 -0400 From: "Alex Deucher" To: "jason@ohloh.net" Subject: Re: SCSI vs SATA Cc: Ron , pgsql-performance@postgresql.org In-Reply-To: <3C1520FD-DE3B-4A16-A7BA-74489D4CC89D@ohloh.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <200704042027.l34KRMI03358@momjian.us> <46140B49.3060205@commandprompt.com> <46140F05.9090403@mochima.com> <649E6F5F-13D0-4D2F-A842-722320FF8F3C@ohloh.net> <3C1520FD-DE3B-4A16-A7BA-74489D4CC89D@ohloh.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/106 X-Sequence-Number: 23983 On 4/5/07, jason@ohloh.net wrote: > > On Apr 5, 2007, at 4:09 AM, Ron wrote: > > > BE VERY WARY OF USING AN ADAPTEC RAID CONTROLLER! > > Thanks - I received similar private emails with the same advice. I > will change the controller to a LSI MegaRAID SAS 8408E -- any > feedback on this one? We use the LSI SAS1064 SAS chips and they've been great. > > > > > IME, they are usually the worst of the commodity RAID controllers > > available. > > I've often seen SW RAID outperform them. > > > > If you are going to use this config, Tyan's n3600M (AKA S2932) MB > > has a variant that comes with 8 SAS + 6 SATA II connectors. > > The SKU is S2932WG2NR. > > http://www.tyan.us/product_board_detail.aspx?pid=453 > > I plan on leveraging the battery backed module so onboard sas isn't a > priority for me. > > > I'm using this beast (Dual Socket F, AMD Barcelona ready, 16 DIMMS > > supporting up to 64GB of ECC RAM, 2 PCI-Ex16 slots w/ PCI-Ex8 > > signalling, etc: > > ~$450 US w/o SAS, ~$500 US w/ SAS) for my most recent pg 8.2.3 > > build on top of XFS. > > I'm curious to know why you're on xfs (i've been too chicken to stray > from ext3). I've had great performance with jfs, however there are some issues with it on certain bigendian platforms. > > > If the on board RAID is or becomes inadequate to your needs, I'd > > strongly suggest either 3ware or Areca RAID controllers. > > I don't know why, but my last attempt at using an areca 1120 w/ linux > on amd64 (and > 4gb ram) was disastrous - i will never use them > again. 3ware's been rock solid for us. > > > > > Side Note: > > What kind of HDs are the 8*73GB ones? If they are the new 2.5" > > Savvio 15Ks, be =VERY= careful about having proper power and > > cooling for them. > > 14 HD's in one case are going to have a serious transient load on > > system start up and (especially with those SAS HDs) can generate a > > great deal of heat. > > I went w/ Fujitsu. Fortunately these servers are hosted in a very > well ventilated area so i am not that concerned with heat issues. > We have the 2.5" drives (seagates and fujitsus) and they have been reliable and performed well. Alex