X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id 053DFD1C4B7 for ; Tue, 22 Jul 2003 14:37:50 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 21904-07 for ; Tue, 22 Jul 2003 14:37:44 +0000 (GMT) Received: from lakemtao01.cox.net (lakemtao01.cox.net [68.1.17.244]) by svr1.postgresql.org (Postfix) with ESMTP id 60504D1C513 for ; Tue, 22 Jul 2003 11:37:45 -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 <20030722143746.HIVE7142.lakemtao01.cox.net@[192.168.1.1]> for ; Tue, 22 Jul 2003 10:37:46 -0400 Subject: Re: Tuning PostgreSQL From: Ron Johnson To: PgSQL Performance ML In-Reply-To: <006801c35050$518c49a0$b696a8c0@APR> References: <3F1C00B2.20319.147235A4@localhost> <1058867576.15449.17.camel@haggis> <006801c35050$518c49a0$b696a8c0@APR> Content-Type: text/plain Message-Id: <1058884665.15452.57.camel@haggis> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.3 Date: 22 Jul 2003 09:37:45 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/355 X-Sequence-Number: 2648 On Tue, 2003-07-22 at 07:53, Alexander Priem wrote: > Wow, I never figured how many different RAID configurations one could think [snip] > Also because of this battery backed cache controller, I will go for the ext2 > file system, mounted with 'noatime'. I will use a UPS, so I don't think I > need the journaling of ext3. Oooooo, I don't think I'd do that!!!!! It's akin to saying, "I don't need to make backups, because I have RAID[1,5,10,1+0] If the power is out for 26 minutes and your UPS only lasts for 25 minutes, you could be in be in for a long, painful boot process if the box crashes. (For example, the UPS auto-shutdown daemon doesn't work properly, and no one can get to the console to shut it down properly before the batteries die.) -- +-----------------------------------------------------------------+ | 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 | +-----------------------------------------------------------------+