X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 7425E4763E4 for ; Fri, 2 May 2003 16:53:34 -0400 (EDT) Received: from utahisp.com (pop3.cyberwires.com [66.239.12.3]) by postgresql.org (Postfix) with ESMTP id D98824763C2 for ; Fri, 2 May 2003 16:53:32 -0400 (EDT) Received: from chad [63.230.8.76] by utahisp.com (SMTPD32-7.14) id A9FB9007012C; Fri, 02 May 2003 14:50:03 -0600 Message-ID: <0c9a01c310ec$e5605d90$32021aac@chad> From: "Chad Thompson" To: , "pgsql-performance" References: <0c2101c310dc$28e3c090$32021aac@chad> <200305021310.46770.josh@agliodbs.com> Subject: Re: Looking for a cheap upgrade (RAID) Date: Fri, 2 May 2003 14:53:33 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Declude-Sender: chad@weblinkservices.com [63.230.8.76] X-Declude-Spoolname: Dd9fb9007012c035e.SMD X-Note: This E-mail was scanned by Declude JunkMail (www.declude.com) for spam. X-Spam-Status: No, hits=-18.7 required=5.0 tests=BAYES_20,ORIGINAL_MESSAGE,QUOTED_EMAIL_TEXT,REFERENCES, SMTPD_IN_RCVD autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/10 X-Sequence-Number: 1789 Can WAL and the swap partition be on the same drive? Thanks Chad ----- Original Message ----- From: "Josh Berkus" To: "Chad Thompson" ; "pgsql-performance" Sent: Friday, May 02, 2003 2:10 PM Subject: Re: [PERFORM] Looking for a cheap upgrade (RAID) Chad, > I realize that Im a raid on linux newbie so any suggestions are appreciated. > Im thinking I want to put this on an IDE Raid array, probably 0+1. IDE seems > to be cheap and effective these days. > What ive been able to glean from other postings is that I should have 3 > drives, 2 for the database w/ striping and another for the WAL. Well, RAID 0+1 is only relevant if you have more than 2 drives. Otherwise, it's just RAID 1 (which is a good choice for PostgreSQL). More disks is almost always better. Putting WAL on a seperate (non-RAID) disk is usually a very good idea. > I would also appreciate raid hardware suggestions (brands, etc) > And as always im not afraid to RTFM if someone can point me to the FM :-) Use Linux Software RAID. To get hardware RAID better than Linux Software RAID, you have to spend $800 or more. -- -Josh Berkus Aglio Database Solutions San Francisco