X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id C9CE6D1B4FD for ; Sat, 27 Sep 2003 19:54:04 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 86889-05 for ; Sat, 27 Sep 2003 16:53:34 -0300 (ADT) Received: from davinci.ethosmedia.com (unknown [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id DD5F7D1B4E3 for ; Sat, 27 Sep 2003 16:53:32 -0300 (ADT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3689644; Sat, 27 Sep 2003 12:54:05 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: rj@last.fm, pgsql-performance@postgresql.org Subject: Re: advice on raid controller Date: Sat, 27 Sep 2003 12:53:04 -0700 User-Agent: KMail/1.4.3 References: <200309271824.33351.rj@last.fm> In-Reply-To: <200309271824.33351.rj@last.fm> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200309271253.04940.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/340 X-Sequence-Number: 3706 RIchard, > Hi, i'm on the verge of buying a "MegaRAID SCSI 320-2" raid controller. > I need it to build a db server using 4x ultra320 scsi disks > i'm thinking raid 1+0 but will try with raid5 too and compare Depends on your type of database. If you're doing web or OLAP (lots of read-only queries) RAID 5 will probably be better. If you're doing OLTP (lots of read-write) RAID 10 will almost certainly be better. But if you have time, testing is always best. > as seen: > http://uk.azzurri.com/product/product.cgi?productId=188 I haven'te used it personally, but what I don't see in the docs is a battery-backed cache. Without battery backup on the write cache, IMHO you are better off with Linux of BSD software RAID, since you'll have to turn off the card's write cache, lest your database get corrupted on power-out. -- Josh Berkus Aglio Database Solutions San Francisco