Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 9CE2F632CB9 for ; Wed, 3 Mar 2010 10:00:54 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 07268-10 for ; Wed, 3 Mar 2010 14:00:35 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.10]) by mail.postgresql.org (Postfix) with ESMTP id A0426632B8A for ; Wed, 3 Mar 2010 10:00:43 -0400 (AST) Received: from [192.168.1.3] (pool-96-244-14-10.bltmmd.fios.verizon.net [96.244.14.10]) by mrelayeu.kundenserver.de (node=mrbap1) with ESMTP (Nemesis) id 0LjLyR-1NABG112tz-00dPrW; Wed, 03 Mar 2010 15:00:36 +0100 Message-ID: <4B8E6B80.9070507@2ndquadrant.com> Date: Wed, 03 Mar 2010 09:00:32 -0500 From: Greg Smith User-Agent: Thunderbird 2.0.0.23 (X11/20090817) MIME-Version: 1.0 To: Francisco Reyes CC: Yeb Havinga , Pgsql performance Subject: Re: 10K vs 15k rpm for analytics References: <4B8D7A6C.3010304@gmail.com> <4B8DA2D4.8000501@2ndquadrant.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V01U2FsdGVkX1+r6Ogj7/ZCa9LNE3hzsUwfnzeWifzPPOxU80T xK007h6uFe/1jAvpMeDL6fyYRZa9mXEJ9Vqpo1Ggm5/DVlJsyG z9o6IrW1DolnhD3xIZ3vLTvT0Q1i6gx X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.164 tagged_above=-10 required=5 tests=AWL=-0.979, BAYES_40=-0.185 X-Spam-Level: X-Archive-Number: 201003/58 X-Sequence-Number: 37883 Francisco Reyes wrote: > Who are you using for SAS? > One thing I like about 3ware is their management utility works under > both FreeBSD and Linux well. 3ware has turned into a division within LSI now, so I have my doubts about their long-term viability as a separate product as well. LSI used to be the reliable, open, but somewhat slower cards around, but that doesn't seem to be the case with their SAS products anymore. I've worked on two systems using their MegaRAID SAS 1078 chipset in RAID10 recently and been very impressed with both. That's what I'm recommending to clients now too--especially people who liked Dell anyway. (HP customers are still getting pointed toward their P400/600/800. 3ware in white box systems, still OK, but only SATA. Areca is fast, but they're really not taking the whole driver thing seriously.) You can get that direct from LSI as the MegaRAID SAS 8888ELP: http://www.lsi.com/storage_home/products_home/internal_raid/megaraid_sas/megaraid_sas_8888elp/ as well as some similar models. And that's what Dell sells as their PERC6. Here's what a typical one looks like from Linux's perspective, just to confirm which card/chipset/driver I'm talking about: # lspci -v 03:00.0 RAID bus controller: LSI Logic / Symbios Logic MegaRAID SAS 1078 (rev 04) Subsystem: Dell PERC 6/i Integrated RAID Controller $ /sbin/modinfo megaraid_sas filename: /lib/modules/2.6.18-164.el5/kernel/drivers/scsi/megaraid/megaraid_sas.ko description: LSI MegaRAID SAS Driver author: megaraidlinux@lsi.com version: 00.00.04.08-RH2 license: GPL As for the management utility, LSI ships "MegaCli[64]" as a statically linked Linux binary. Plenty of reports of people running it on FreeBSD with no problems via Linux emulation libraries--it's a really basic CLI tool and whatever interface it talks to card via seems to emulate just fine. UI is awful, but once you find the magic cheat sheet at http://tools.rapidsoft.de/perc/ it's not too bad. No direct SMART monitoring here either, which is disappointing, but you can get some pretty detailed data out of MegaCli so it's not terrible. I've seen >100MB/s per drive on reads out of small RAID10 arrays, and cleared 1GB/s on larger ones (all on RHEL5+ext3) with this controller on recent installs. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.us