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 A567611F675A for ; Sat, 15 Apr 2006 05:33:01 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.12 X-Spam-Level: X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id znfiaWKdP7jq for ; Sat, 15 Apr 2006 05:32:56 -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 7992B11F626B for ; Sat, 15 Apr 2006 05:32:58 -0300 (ADT) Received: from localhost (smarty [127.0.0.1]) by smarty.gabriel.co.hu (Postfix) with ESMTP id D8E35434CE; Sat, 15 Apr 2006 10:32:55 +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; Sat, 15 Apr 2006 10:32:55 +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 A9310434B4; Sat, 15 Apr 2006 10:32:55 +0200 (CEST) Message-ID: <4440AFB8.4080806@i-logic.hu> Date: Sat, 15 Apr 2006 10:32:56 +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> 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/347 X-Sequence-Number: 18431 Francisco Reyes wrote: > That is certainly something worth considering... Still I wonder if 2 > more spindles will help enough to justify going to RAID 5. My > understanding is that RAID10 has simpler computations requirements which > is partly what makes it better for lots of random read/write. you are right. raid5 is definitely not suitable for database activities. it is good for file servers, though. -- Üdvözlettel, Gábriel Ákos -=E-Mail :akos.gabriel@i-logic.hu|Web: http://www.i-logic.hu=- -=Tel/fax:+3612367353 |Mobil:+36209278894 =-