Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 7D5446407CB for ; Tue, 2 Mar 2010 18:37:35 -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 34616-05-4 for ; Tue, 2 Mar 2010 22:37:19 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from madmax.bizintegrators.com (madmax.bizintegrators.com [64.94.184.54]) by mail.postgresql.org (Postfix) with ESMTP id B9507640C1F for ; Tue, 2 Mar 2010 17:53:08 -0400 (AST) Received: from shelca (p65-147.acedsl.com [66.114.65.147]) (authenticated bits=0) by madmax.bizintegrators.com (8.13.4/8.13.4) with ESMTP id o22Lr3s9010921 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 2 Mar 2010 16:53:03 -0500 (EST) References: <4B8D7A6C.3010304@gmail.com> <4B8D7D18.9030407@2ndquadrant.com> Message-ID: X-Mailer: http://www.courier-mta.org/cone/ From: Francisco Reyes To: Greg Smith Cc: Yeb Havinga , Pgsql performance Subject: Re: 10K vs 15k rpm for analytics Date: Tue, 02 Mar 2010 16:53:09 -0500 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="US-ASCII" Content-Disposition: inline Content-Transfer-Encoding: 7bit X-Loftmail-Check: No X-Scanned-By: MIMEDefang 2.57 on 64.94.184.88 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.699 tagged_above=-10 required=5 tests=AWL=-0.700, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201003/36 X-Sequence-Number: 37861 Greg Smith writes: > 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 Any links/suggested reading on "read-ahead adjustment". I understand this may be OS specific, but any info would be helpfull. Currently have 24 x 10K rpm drives and only getting about 400MB/sec.