X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 09CB74763EC for ; Fri, 2 May 2003 14:53:51 -0400 (EDT) Received: from utahisp.com (mail.utahisp.com [66.239.12.3]) by postgresql.org (Postfix) with ESMTP id DAF144763F8 for ; Fri, 2 May 2003 14:53:45 -0400 (EDT) Received: from chad [63.230.8.76] by utahisp.com (SMTPD32-7.14) id ADE8D8630268; Fri, 02 May 2003 12:50:16 -0600 Message-ID: <0c2101c310dc$28e3c090$32021aac@chad> From: "Chad Thompson" To: "pgsql-performance" Subject: Looking for a cheap upgrade (RAID) Date: Fri, 2 May 2003 12:53:45 -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: Dbde8d86302685945.SMD X-Note: This E-mail was scanned by Declude JunkMail (www.declude.com) for spam. X-Spam-Status: No, hits=-2.7 required=5.0 tests=BAYES_20,SMTPD_IN_RCVD version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/7 X-Sequence-Number: 1786 I have a server on a standard pc right now. PIII 700, 1Gig ram (SD), 40 Gig IDE, RedHat 8.0, PostgreSQL 7.3.1 The database has 3 tables that just broke 10 million tuples (yeah, i think im entering in to the world of real databases ;-) Its primarly bulk (copy) inserts and queries, rarely an update. I am looking at moving this to a P4 2.4G, 2 Gig Ram(DDR), RedHat 8, PostgreSQL 7.3.latest My primary reason for posting this is to help filter through the noise, and get me pointed in the right direction. 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. Am I way off base here? 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 :-) Cost seems to be quite a high priority, I'm getting pretty good at making something out of nothing for everyone :) TIA for any suggestions. Chad