X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.225.181]) by svr1.postgresql.org (Postfix) with ESMTP id 0458CD1C4DB for ; Tue, 22 Jul 2003 15:36:43 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr5.postgresql.org [64.117.225.181]) (amavisd-new, port 10024) with ESMTP id 49112-06 for ; Tue, 22 Jul 2003 15:36:31 +0000 (GMT) Received: from lakemtao01.cox.net (lakemtao01.cox.net [68.1.17.244]) by svr1.postgresql.org (Postfix) with ESMTP id 94B73D1C93C for ; Tue, 22 Jul 2003 12:36:31 -0300 (ADT) Received: from [192.168.1.1] ([68.11.66.83]) by lakemtao01.cox.net (InterMail vM.5.01.04.05 201-253-122-122-105-20011231) with ESMTP id <20030722153631.HYXP7142.lakemtao01.cox.net@[192.168.1.1]> for ; Tue, 22 Jul 2003 11:36:31 -0400 Subject: Re: Tuning PostgreSQL From: Ron Johnson To: PgSQL Performance ML In-Reply-To: <00d301c35062$25c943b0$b696a8c0@APR> References: <9B1C77393DED0D4B9DAA1AA1742942DA3BCCB1@pos_pdc.posportal.com> <014a01c34f90$74bc2c80$b696a8c0@APR> <200307210906.10226.josh@agliodbs.com> <20030721162852.GN19009@md2.mediadesign.nl> <002901c3501f$86565940$b696a8c0@APR> <20030722094035.GU19009@md2.mediadesign.nl> <009901c35054$fad824d0$b696a8c0@APR> <20030722143335.GH55392@nasby.net> <00d301c35062$25c943b0$b696a8c0@APR> Content-Type: text/plain Message-Id: <1058888190.15449.94.camel@haggis> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.3 Date: 22 Jul 2003 10:36:30 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/358 X-Sequence-Number: 2651 On Tue, 2003-07-22 at 10:01, Alexander Priem wrote: > OK, another change of plans :) > > ext2 seems to be a bad idea. So i'll stick with ext3. Better safe than > sorry... Don't forget noatime! > About the RAID-config: Maybe RAID-10 with six disks is affordable after all. > I would have to take the smallest disks in this case, 18Gb per disk. So six > 18Gb disks (15000rpm) would result in a total capacity of 54 Gb, right? This > volume would hold OS, WAL and data, but since RAID10 appears to deliver such > great performance (according to several people), in combination with the > 128Mb of battery backed cache, this would be a good solution? > > Hmmm. I keep changing my mind about this. My Db would be mostly 'selecting', > but there would also be pretty much inserting and updating done. But most of > the work would be selects. So would this config be OK? Others may disagree, but I'd put the OS and executables on a separate disk from the db and WAL, and make it an IDE drive, since it's so much less expensive than SCSI disks. (Make a copy of the disk, and if it craps out, pop out the old disk, stick in the new disk, and fire the box right back up...) Thus, you'll have an OS/executables disk, and a separate DB disk, and never the twain shall meet. Theoretically, you could pick up those 6 drives and controller, move them to another machine, and the data should be just as it was on the other box. -- +-----------------------------------------------------------------+ | Ron Johnson, Jr. Home: ron.l.johnson@cox.net | | Jefferson, LA USA | | | | "I'm not a vegetarian because I love animals, I'm a vegetarian | | because I hate vegetables!" | | unknown | +-----------------------------------------------------------------+