X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DA4D43A586C for ; Tue, 11 Jan 2005 04:31:12 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 94777-02 for ; Tue, 11 Jan 2005 04:31:09 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 260A33A573D for ; Tue, 11 Jan 2005 04:31:09 +0000 (GMT) Received: from [192.168.1.20] (clbb-248.saw.net [64.146.135.248]) (authenticated bits=0) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j0B4V5Q0007447; Mon, 10 Jan 2005 20:31:06 -0800 Message-ID: <41E3569A.4030102@commandprompt.com> Date: Mon, 10 Jan 2005 20:31:22 -0800 From: "Joshua D. Drake" User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Christopher Browne Cc: pgsql-performance@postgresql.org Subject: Re: which dual-CPU hardware/OS is fastest for PostgreSQL? References: <59b2d39b05011018421680264b@mail.gmail.com> In-Reply-To: Content-Type: multipart/mixed; boundary="------------040301030800010906080008" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.039 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/124 X-Sequence-Number: 9814 This is a multi-part message in MIME format. --------------040301030800010906080008 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit > >RAID controllers tend to use i960 or StrongARM CPUs that run at speeds >that _aren't_ all that impressive. With software RAID, you can take >advantage of the _enormous_ increases in the speed of the main CPU. > >I don't know so much about FreeBSD's handling of this, but on Linux, >there's pretty strong indication that _SOFTWARE_ RAID is faster than >hardware RAID. > > Unless something has changed though, you can't run raid 10 with linux software raid and raid 5 sucks for heavy writes. J >It has the further merit that you're not dependent on some disk >formatting scheme that is only compatible with the model of RAID >controller that you've got, where if the controller breaks down, you >likely have to rebuild the whole array from scratch and your data is >toast. > >The assumptions change if you're looking at really high end disk >arrays, but that's certainly another story. > > -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL --------------040301030800010906080008 Content-Type: text/x-vcard; charset=utf-8; name="jd.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jd.vcf" begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard --------------040301030800010906080008--