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 F247C3A624A for ; Tue, 7 Dec 2004 15:19:37 +0000 (GMT) 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 06185-01 for ; Tue, 7 Dec 2004 15:19:31 +0000 (GMT) Received: from smtp104.rog.mail.re2.yahoo.com (smtp104.rog.mail.re2.yahoo.com [206.190.36.82]) by svr1.postgresql.org (Postfix) with SMTP id 9D5423A6230 for ; Tue, 7 Dec 2004 15:19:32 +0000 (GMT) Received: from unknown (HELO phlogiston.dydns.org) (a.sullivan@rogers.com@65.49.125.184 with login) by smtp104.rog.mail.re2.yahoo.com with SMTP; 7 Dec 2004 15:19:33 -0000 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 9F26240DC; Tue, 7 Dec 2004 10:19:26 -0500 (EST) Date: Tue, 7 Dec 2004 10:19:26 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Config review Message-ID: <20041207151926.GD27594@phlogiston.dyndns.org> Mail-Followup-To: pgsql-performance@postgresql.org References: <41B46F52.4000607@bright.net> <87r7m2zgar.fsf@stark.xeocode.com> <15131.1102432074@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <15131.1102432074@sss.pgh.pa.us> User-Agent: Mutt/1.5.6+20040722i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.035 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200412/135 X-Sequence-Number: 9510 On Tue, Dec 07, 2004 at 10:07:54AM -0500, Tom Lane wrote: > If you are using a RAID configuration it might just be that you need > to adjust the configuration (IIRC, there are some RAID setups that > are not very write-friendly). Otherwise you may have little alternative > but to buy faster disks. It might be that altering the Clariion array from RAID 5 to RAID 1+0 would make a difference; but I'd be very surprised to learn that you could get that array to go a whole lot faster. One thing that might also be worth investigating is whether performance actually goes up by moveing the WAL into the array. We've had some remarkably good experiences with our recently-acquired EMC. A -- Andrew Sullivan | ajs@crankycanuck.ca When my information changes, I alter my conclusions. What do you do sir? --attr. John Maynard Keynes