X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 90E269FB232 for ; Fri, 15 Sep 2006 01:01:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 54358-07 for ; Fri, 15 Sep 2006 04:01:32 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from lists.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id E13EE9FB1BA for ; Fri, 15 Sep 2006 01:01:27 -0300 (ADT) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id k8F41SrG020089 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Thu, 14 Sep 2006 21:01:29 -0700 Message-ID: <450A2594.8080404@commandprompt.com> Date: Thu, 14 Sep 2006 21:01:24 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Thunderbird 1.5.0.5 (X11/20060728) MIME-Version: 1.0 To: Luke Lonergan CC: "Craig A. James" , pgsql-performance@postgresql.org Subject: Re: RAID 0 not as fast as expected References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88.3, clamav-milter version 0.88.3 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Thu, 14 Sep 2006 21:01:29 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.951 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, SPF_HELO_SOFTFAIL, SPF_SOFTFAIL X-Spam-Level: *** X-Archive-Number: 200609/198 X-Sequence-Number: 20884 Luke Lonergan wrote: > Josh, > > On 9/14/06 8:47 PM, "Joshua D. Drake" wrote: > >>> I've obtained 1,950 MB/s using Linux software RAID on SATA drives. >> With what? :) > > Sun X4500 (aka Thumper) running stock RedHat 4.3 (actually CentOS 4.3) with > XFS and the linux md driver without lvm. Here is a summary of the results: > Good god! > > Read Test > RAID Level Max Readahead (KB) RAID Chunksize Max Readahead on Disks (KB) > Max Time (s) Read Bandwidth (MB/s) > 0 65536 64 256 16.689 1,917.43 > 0 4096 64 256 21.269 1,504.54 > 0 65536 256 256 17.967 1,781.04 > 0 2816 256 256 18.835 1,698.96 > 0 65536 1024 256 18.538 1,726.18 > 0 65536 64 512 18.295 1,749.11 > 0 65536 64 256 18.931 1,690.35 > 0 65536 64 256 18.873 1,695.54 > 0 64768 64 256 18.545 1,725.53 > 0 131172 64 256 18.548 1,725.25 > 0 131172 64 65536 19.046 1,680.14 > 0 131172 64 524288 18.125 1,765.52 > 0 131172 64 1048576 18.701 1,711.14 > 5 2560 64 256 39.933 801.34 > 5 16777216 64 256 37.76 847.46 > 5 524288 64 256 53.497 598.16 > 5 65536 32 256 38.472 831.77 > 5 65536 32 256 38.004 842.02 > 5 65536 32 256 37.884 844.68 > 5 2560 16 256 41.39 773.13 > 5 65536 16 256 48.902 654.37 > 10 65536 64 256 83.256 384.36 > 1+0 65536 64 256 19.394 1,649.99 > 1+0 65536 64 256 19.047 1,680.05 > 1+0 65536 64 256 19.195 1,667.10 > 1+0 65536 64 256 18.806 1,701.58 > 1+0 65536 64 256 18.848 1,697.79 > 1+0 65536 64 256 18.371 1,741.88 > 1+0 65536 64 256 21.446 1,492.12 > 1+0 65536 64 256 20.254 1,579.93 > > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/