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 8BA3353429 for ; Wed, 20 Apr 2005 00:06:59 -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 90658-10 for ; Wed, 20 Apr 2005 03:06:57 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9C9C15340B for ; Wed, 20 Apr 2005 00:06:56 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 58E2E30952; Wed, 20 Apr 2005 05:05:50 +0200 (MET DST) From: William Yu X-Newsgroups: pgsql.performance Subject: Re: What to do with 6 disks? Date: Tue, 19 Apr 2005 20:06:54 -0700 Organization: Hub.Org Networking Services Lines: 23 Message-ID: References: <200504191610.j3JGAM820841@candle.pha.pa.us> <20050420001523.GU58835@decibel.org> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en In-Reply-To: To: pgsql-performance@postgresql.org 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: 200504/484 X-Sequence-Number: 11881 My experience: 1xRAID10 for postgres 1xRAID1 for OS + WAL Jeff Frost wrote: > Now that we've hashed out which drives are quicker and more money equals > faster... > > Let's say you had a server with 6 separate 15k RPM SCSI disks, what raid > option would you use for a standalone postgres server? > > a) 3xRAID1 - 1 for data, 1 for xlog, 1 for os? > b) 1xRAID1 for OS/xlog, 1xRAID5 for data > c) 1xRAID10 for OS/xlong/data > d) 1xRAID1 for OS, 1xRAID10 for data > e) ..... > > I was initially leaning towards b, but after talking to Josh a bit, I > suspect that with only 4 disks the raid5 might be a performance > detriment vs 3 raid 1s or some sort of split raid10 setup. >