Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 65C3D1336FA7 for ; Thu, 3 Feb 2011 01:46:16 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 84184-09 for ; Thu, 3 Feb 2011 05:46:09 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.187]) by mail.postgresql.org (Postfix) with ESMTP id C6FB8133616B for ; Thu, 3 Feb 2011 01:46:08 -0400 (AST) Received: from [192.168.1.6] (mail.highperformancepostgresql.com [71.179.240.8]) by mrelayeu.kundenserver.de (node=mreu0) with ESMTP (Nemesis) id 0MSVhA-1Pd8o63ri0-00Rcps; Thu, 03 Feb 2011 06:46:07 +0100 Message-ID: <4D4A411A.3040102@2ndquadrant.com> Date: Thu, 03 Feb 2011 00:46:02 -0500 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: Dan Birken CC: pgsql-performance Subject: Re: Which RAID Controllers to pick/avoid? References: In-Reply-To: Content-Type: multipart/alternative; boundary="------------090200080605040104040708" X-Provags-ID: V02:K0:bkp3ky1TbhvUflPpwpbPd0GmuIfEpGT9VyC3moVTG1u i2POrirFTL+a199qI86NrrNGG3oYLwfspv8uKk8Tv6NnQ+UphO lwWYX0eeCRwOQCLL1MbTtEAVcA8muQQrkn6xybyaA5QCtSn22v Rml+9SswVr/PlNJ/Aq/Fkh24j5fBs1QtSCL8TjRTx81mTXYyqd H+PFUvSywVlROVFp+yF69HNzRBtbsvVrnooTZELCIA= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201102/59 X-Sequence-Number: 42197 This is a multi-part message in MIME format. --------------090200080605040104040708 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Dan Birken wrote: > ADAPTEC 3405 RAID Controller > ADAPTEC 4800 RAID Controller The 3405 and 4800 are two of Adaptec's older cards with only 128MB of cache on them. Those are on the slow side compared to the others listed. > LSI MegaRaid 8308 RAID Controller > ADAPTEC 5405 RAID Controller > ADAPTEC 5405Z RAID Controller > ADAPTEC 5805 RAID Controller > ADAPTEC 5805Z RAID Controller The LSI cards are some of the most popular and known to work well with PostgreSQL ones around. I've recently tested a system based on the 5405, and as much as I've hated Adaptec controllers in the past I have to admit this latest line from them is pretty solid. My own benchmarks and the others I've seen suggest it's easily capable of keeping up with the LSI and Areca controllers Adaptec used to be seriously outrun by. See http://www.tomshardware.com/reviews/adaptec-serial-controllers,1806-14.html for example. The "Z" variations use their "Zero-Maintenance Cache" instead of a standard battery-backup unit; that's a small amount of flash memory and a supercap, similar to the good caches on SSD: http://www.adaptec.com/NR/rdonlyres/7FD8C372-8231-4727-B12B-5ABF79D9325C/0/6514_Series5Z_1_7.pdf 5405 has 256MB of cache, the others 512MB. The 5405 and 5805 models do have a known problem where they overheat if you don't have enough cooling in the server box, with the 5805 seeming to be the bigger source of such issues. See the reviews at http://www.newegg.com/Product/Product.aspx?Item=N82E16816103099 for example. Scott Marlowe was griping recently about a similar issue in some of the LSI models, too. I suspect it's a problem impacting several of the larger RAID cards that use the big Intel IOP processors for their RAID computations, given that's the part with the heatsink on it. Quick summary: avoid the Adaptec 3405 and 4800. Rest are decent cards. Just make sure you monitor the temperatures in your case (and the card too if arcconf lets you, I haven't checked for that yet) if you end up with a 5405/5805. -- Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books --------------090200080605040104040708 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Dan Birken wrote:
 ADAPTEC 3405 RAID Controller
 ADAPTEC 4800 RAID Controller

The 3405 and 4800 are two of Adaptec's older cards with only 128MB of cache on them.  Those are on the slow side compared to the others listed.

  LSI MegaRaid 8308 RAID Controller
 ADAPTEC 5405 RAID Controller
 ADAPTEC 5405Z RAID Controller
 ADAPTEC 5805 RAID Controller
 ADAPTEC 5805Z RAID Controller

The LSI cards are some of the most popular and known to work well with PostgreSQL ones around.

I've recently tested a system based on the 5405, and as much as I've hated Adaptec controllers in the past I have to admit this latest line from them is pretty solid.  My own benchmarks and the others I've seen suggest it's easily capable of keeping up with the LSI and Areca controllers Adaptec used to be seriously outrun by.  See http://www.tomshardware.com/reviews/adaptec-serial-controllers,1806-14.html for example.

The "Z" variations use their "Zero-Maintenance Cache" instead of a standard battery-backup unit; that's a small amount of flash memory and a supercap, similar to the good caches on SSD:  http://www.adaptec.com/NR/rdonlyres/7FD8C372-8231-4727-B12B-5ABF79D9325C/0/6514_Series5Z_1_7.pdf

5405 has 256MB of cache, the others 512MB.

The 5405 and 5805 models do have a known problem where they overheat if you don't have enough cooling in the server box, with the 5805 seeming to be the bigger source of such issues.  See the reviews at http://www.newegg.com/Product/Product.aspx?Item=N82E16816103099 for example.  Scott Marlowe was griping recently about a similar issue in some of the LSI models, too.  I suspect it's a problem impacting several of the larger RAID cards that use the big Intel IOP processors for their RAID computations, given that's the part with the heatsink on it.

Quick summary:  avoid the Adaptec 3405 and 4800.  Rest are decent cards.  Just make sure you monitor the temperatures in your case (and the card too if arcconf lets you, I haven't checked for that yet) if you end up with a 5405/5805.

-- 
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books
--------------090200080605040104040708--