X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id DBEA311F6ACB for ; Sat, 15 Apr 2006 05:35:43 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.08 X-Spam-Level: X-Spam-Status: No, score=0.08 required=5 tests=[AWL=0.080] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id J3FhZRMnSVkp for ; Sat, 15 Apr 2006 05:35:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smarty.gabriel.co.hu (smarty.gabriel.co.hu [195.70.37.16]) by postgresql.org (Postfix) with ESMTP id 4A47911F626B for ; Sat, 15 Apr 2006 05:35:41 -0300 (ADT) Received: from localhost (smarty [127.0.0.1]) by smarty.gabriel.co.hu (Postfix) with ESMTP id CC3ED434CE; Sat, 15 Apr 2006 10:35:40 +0200 (CEST) Received: from smarty.gabriel.co.hu ([127.0.0.1]) by localhost (smarty [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 04867-04-3; Sat, 15 Apr 2006 10:35:40 +0200 (CEST) Received: from [192.168.100.182] (catv-5062cfe4.catv.broadband.hu [80.98.207.228]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by smarty.gabriel.co.hu (Postfix) with ESMTP id A95214345B; Sat, 15 Apr 2006 10:35:40 +0200 (CEST) Message-ID: <4440B05D.8070002@i-logic.hu> Date: Sat, 15 Apr 2006 10:35:41 +0200 From: =?ISO-8859-1?Q?G=E1briel_=C1kos?= Organization: I-Logic Kft User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: Francisco Reyes Cc: Michael Stone , pgsql-performance@postgresql.org Subject: Re: Inserts optimization? References: <443DA715.4060606@gmail.com> <9549.1144903344@sss.pgh.pa.us> <20060414055923.GX49405@pervasive.com> <20060414114911.GG32678@mathom.us> <20060414190620.GH32678@mathom.us> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at gabriel.co.hu X-Archive-Number: 200604/348 X-Sequence-Number: 18432 Francisco Reyes wrote: > Michael Stone writes: > >> I still don't follow that. Why would the RAID level matter? IOW, are >> you actually wanting 2 spares, or are you just stick with that because >> you need a factor of two disks for your mirrors? > > RAID 10 needs pairs.. so we can either have no spares or 2 spares. hm, interesting. I have recently set up a HP machine with smartarray 6i controller, and it is able to handle 4 disks in raid10 plus 1 as spare. with some scripting you can even use linux software raid in the same setup. -- Üdvözlettel, Gábriel Ákos -=E-Mail :akos.gabriel@i-logic.hu|Web: http://www.i-logic.hu=- -=Tel/fax:+3612367353 |Mobil:+36209278894 =-