X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9965E47638C for ; Tue, 22 Apr 2003 08:11:50 -0400 (EDT) Received: from mail2.mediadesign.nl (md2.mediadesign.nl [212.19.205.67]) by postgresql.org (Postfix) with SMTP id 5126A476373 for ; Tue, 22 Apr 2003 08:11:49 -0400 (EDT) Received: (qmail 28210 invoked by uid 666); 22 Apr 2003 12:11:50 -0000 Date: Tue, 22 Apr 2003 14:11:50 +0200 From: Vincent van Leeuwen To: pgsql-performance@postgresql.org Subject: Re: the RAID question, again Message-ID: <20030422121150.GU1836@md2.mediadesign.nl> Mail-Followup-To: pgsql-performance@postgresql.org References: <20030416193256.25788.h006.c001.wm@mail.dilger.cc.criticalpath.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20030416193256.25788.h006.c001.wm@mail.dilger.cc.criticalpath.net> User-Agent: Mutt/1.3.28i X-Spam-Status: No, hits=-38.0 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_MUTT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/190 X-Sequence-Number: 1696 On 2003-04-16 19:32:54 -0700, Nikolaus Dilger wrote: > One improvement area may be to put all 6 disks into a > RAID 10 group. That way you have more I/O bandwith. A concern I have about that setup is that a large WAL write will have to wait for 6 spindles to write the data before returning instead of 2 spindles. But as you say it does create way more I/O bandwidth. I think I'll just test that when the box is here instead of speculating further :) > One watchout is that the main memory of your machine > may be better than the one of your RAID controller. > The RAID controller has Integrated 128MB PC133 ECC > SDRAM. You did not state what kind of memory your > server has. > On 2003-04-16 20:20:50 -0700, Josh Berkus wrote: > Nickolaus has a good point. With a high-end Linux server, and a medium-end > RAID card, it's sometimes faster to use Linux software RAID than harware > raid. Not all the time, though. I've heard rumors that software raid performs poor when stacking raid layers (raid 0 on raid 1). Not sure if that's still true though. My own experiences with linux software raid (raid 5 on a low-cost fileserver for personal use) are very good (especially in the reliability department, I've recovered from two-disk failures due to controllers hanging up with only a few percent data loss), although I've never been overly concerned with performance on that setup so haven't really tested that. But if this controller is medium-end, could anyone recommend a high-end RAID card that has excellent linux support? One of the things I especially like about ICP Vortex products is the official linux support and the excellent software utility for monitoring and (re)configuring the raid arrays. Comes in handy when replacing hot-spares and rebuilding failed arrays while keeping the box running :) Vincent van Leeuwen Media Design - http://www.mediadesign.nl/