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 63D1352840 for ; Wed, 1 Jun 2005 11:15:33 -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 13218-02 for ; Wed, 1 Jun 2005 14:15:24 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 5D4F352954 for ; Wed, 1 Jun 2005 11:15:24 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j51EFNfI025569 for ; Wed, 1 Jun 2005 14:15:23 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j51Dvi62069200 for pgsql-admin@postgresql.org; Wed, 1 Jun 2005 13:57:44 GMT (envelope-from news) From: Cris Carampa X-Newsgroups: pgsql.admin Subject: RAID0 vs RAID1 vs RAID? Date: Wed, 01 Jun 2005 15:57:26 +0200 Organization: Hub.Org Networking Services Lines: 24 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040114 X-Accept-Language: it, en-us To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200506/16 X-Sequence-Number: 17771 Hello all. I have a production postgresql 7.4.5 database on a HP Proliant ML330 G3 server, OS: SUSE SLES8, two SCSI disks in RAID1. I just cloned the same database (same data) on another server. It's another HP Proliant ML330 G3 with SUSE SLES8 on but it has the latest 7.4.x release (7.4.8) and the disks are two ATA disks in RAID0. The same queries run 6 times faster on the second server! 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? Thank you. Kind regards, -- Cris Carampa (cris119@operamail.com) "E` evidente che siamo di fronte allo sfruttamento opportunistico di quella quota di astensioni fatalmente derivanti da disinteresse o indifferenza." (Gustavo Zagrebelsky)