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 365BE3A2015 for ; Fri, 14 Jan 2005 23:35:00 +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 34029-08 for ; Fri, 14 Jan 2005 23:34:52 +0000 (GMT) Received: from zoidberg.portrix.net (mail.portrix.net [212.202.157.208]) by svr1.postgresql.org (Postfix) with ESMTP id C22CE3A25A4 for ; Fri, 14 Jan 2005 23:34:53 +0000 (GMT) Received: from [127.0.0.1] (fry.portrix.net [212.202.157.213]) (authenticated bits=0) by zoidberg.portrix.net (8.12.3/8.12.3/Debian-7.1) with ESMTP id j0ENYdjV024779 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO); Sat, 15 Jan 2005 00:34:42 +0100 Message-ID: <41E856A7.6080804@portrix.net> Date: Sat, 15 Jan 2005 00:32:55 +0100 From: Jan Dittmer Organization: portrix.net GmbH User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.5) Gecko/20041124 Thunderbird/0.9 Mnenhy/0.6.0.104 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Greg Stark Cc: "Joshua D. Drake" , Christopher Browne , pgsql-performance@postgresql.org Subject: Re: which dual-CPU hardware/OS is fastest for PostgreSQL? References: <59b2d39b05011018421680264b@mail.gmail.com> <41E3569A.4030102@commandprompt.com> <41E3A780.3020505@portrix.net> <87is60ug7z.fsf@stark.xeocode.com> In-Reply-To: <87is60ug7z.fsf@stark.xeocode.com> X-Enigmail-Version: 0.89.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200501/195 X-Sequence-Number: 9885 Greg Stark wrote: > Jan Dittmer writes: > > >>You could always do raid 1 over raid 0, with newer kernels (2.6ish) >>there is even a dedicated raid10 driver. > > > Aren't you much better off doing raid 0 over raid 1? > > With raid 1 over raid 0 you're mirroring two stripe sets. That means if any > drive from the first stripe set goes you lose the whole side of the mirror. If > any drive of the second stripe set goes you lost your array. Even if they're > not the same position in the array. > > If you do raid 0 over raid 1 then you're striping a series of mirrored drives. > So if any drive fails you only lose that drive from the stripe set. If another > drive fails then you're ok as long as it isn't the specific drive that was > paired with the first failed drive. Ever heart of Murphy? :-) But of course you're right - I tend to mix up the raid levels... Jan