X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4A79052851 for ; Mon, 6 Jun 2005 12:33:18 -0300 (ADT) 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 12453-05 for ; Mon, 6 Jun 2005 15:33:09 +0000 (GMT) Received: from smtp.igda.it (unknown [194.185.232.62]) by svr1.postgresql.org (Postfix) with ESMTP id 3048852812 for ; Mon, 6 Jun 2005 12:33:07 -0300 (ADT) Received: from [155.10.40.50] (smtp [140.10.9.5]) by smtp.igda.it (Postfix) with ESMTP id 18C02C01E; Mon, 6 Jun 2005 17:33:05 +0200 (CEST) Message-ID: <42A46CB0.7000903@deagostini.it> Date: Mon, 06 Jun 2005 17:33:04 +0200 From: Rodolfo Baselli Organization: De Agostini Professionale User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.7) Gecko/20050414 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Cc: Cris Carampa Subject: Re: RAID0 vs RAID1 vs RAID? References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed 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: 200506/26 X-Sequence-Number: 17781 Cris Carampa wrote: > Is it possible that RAID0 is 6 times faster than RAID1? Since RAID0 has > no fault tolerance, what is the RAID configuration that gives maximum > performance and reliability? RAID10? Short (same old) answer: it depends. It's no surprise that RAID0 outperforms RAID1 expecially in the write performance. Fault tolerance is has its own overhead. A smart RAID controller takes advantage in read operations in both cases, but it's definitely different in write operations. You have to check whether your db configuration or application dml statements affect the performance tests (eg. they are the most frequent operations). Bye -- Rodolfo Baselli Wolters Kluver Italia Professionale "I'm no supervising technician, I'm a technical supervisor." - Homer Simpson