Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id B2FFC632D02 for ; Tue, 2 Mar 2010 17:03:38 -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 16310-04 for ; Tue, 2 Mar 2010 21:03:23 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.9]) by mail.postgresql.org (Postfix) with ESMTP id D8342632C4E for ; Tue, 2 Mar 2010 17:03:26 -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=mreu1) with ESMTP (Nemesis) id 0MRQMu-1OAeeI1DgG-00SkAj; Tue, 02 Mar 2010 22:03:24 +0100 Message-ID: <4B8D7D18.9030407@2ndquadrant.com> Date: Tue, 02 Mar 2010 16:03:20 -0500 From: Greg Smith User-Agent: Thunderbird 2.0.0.23 (X11/20090817) MIME-Version: 1.0 To: Yeb Havinga CC: Francisco Reyes , Pgsql performance Subject: Re: 10K vs 15k rpm for analytics References: <4B8D7A6C.3010304@gmail.com> In-Reply-To: <4B8D7A6C.3010304@gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V01U2FsdGVkX18PAm/BlG+kOvmQ1sNTKUBLLIDrxmhuZ8LW1C0 V21vruLeK/rUGSo4fZHMpswZC51pC7REdHhF4IMobwWBZ7cmbK 5jRdXbInZEICOlkMdonFLtQLP1se42Z X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.17 tagged_above=-10 required=5 tests=AWL=-0.985, BAYES_40=-0.185 X-Spam-Level: X-Archive-Number: 201003/25 X-Sequence-Number: 37850 Yeb Havinga wrote: > With 24 drives it'll probably be the controller that is the limiting > factor of bandwidth. Our HP SAN controller with 28 15K drives delivers > 170MB/s at maximum with raid 0 and about 155MB/s with raid 1+0. You should be able to clear 1GB/s on sequential reads with 28 15K drives in a RAID10, given proper read-ahead adjustment. I get over 200MB/s out of the 3-disk RAID0 on my home server without even trying hard. Can you share what HP SAN controller you're using? -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.us