X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 66E3D9FA261 for ; Tue, 2 May 2006 15:41:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 54879-01 for ; Tue, 2 May 2006 15:41:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.clickspace.com (router2.clickspace.com [65.110.166.227]) by postgresql.org (Postfix) with ESMTP id 7EEFF9F9CC1 for ; Tue, 2 May 2006 15:41:06 -0300 (ADT) Received: from localhost ([127.0.0.1]) by mail.clickspace.com (using TLSv1/SSLv3 with cipher RC4-SHA (128 bits)); Tue, 2 May 2006 12:41:01 -0600 In-Reply-To: <20060502171617.GZ97354@pervasive.com> References: <444F24E9.2010907@lisasoft.com> <20060502171617.GZ97354@pervasive.com> Mime-Version: 1.0 (Apple Message framework v749.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <622925BE-A31E-42FD-AF6A-68DDF3B4A1B7@clickspace.com> Cc: Eric Lam , pgsql-performance@postgresql.org Content-Transfer-Encoding: 7bit From: Brendan Duddridge Subject: Re: Slow restoration question Date: Tue, 2 May 2006 12:40:43 -0600 To: Jim C. Nasby X-Mailer: Apple Mail (2.749.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/32 X-Sequence-Number: 18819 Everyone here always says that RAID 5 isn't good for Postgres. We have an Apple Xserve RAID configured with RAID 5. We chose RAID 5 because Apple said their Xserve RAID was "optimized" for RAID 5. Not sure if we made the right decision though. They give an option for formatting as RAID 0+1. Is that the same as RAID 10 that everyone talks about? Or is it the reverse? Thanks, ____________________________________________________________________ Brendan Duddridge | CTO | 403-277-5591 x24 | brendan@clickspace.com ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB T2G 0V9 http://www.clickspace.com On May 2, 2006, at 11:16 AM, Jim C. Nasby wrote: > On Wed, Apr 26, 2006 at 05:14:41PM +0930, Eric Lam wrote: >> all dumpfiles total about 17Gb. It has been running for 50ish hrs >> and up >> to about the fourth file (5-6 ish Gb) and this is on a raid 5 server. > > RAID5 generally doesn't bode too well for performance; that could be > part of the issue. > -- > Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com > Pervasive Software http://pervasive.com work: 512-231-6117 > vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org >