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 79867D1C4B7 for ; Tue, 22 Jul 2003 14:11:13 +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 93519-09 for ; Tue, 22 Jul 2003 14:11:07 +0000 (GMT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id A887ED1C4CA for ; Tue, 22 Jul 2003 11:11:09 -0300 (ADT) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 19exrB-0002sg-00 for ; Tue, 22 Jul 2003 10:11:09 -0400 Received: by dba2 (Postfix, from userid 1019) id 78A8ACEC9; Tue, 22 Jul 2003 10:12:20 -0400 (EDT) Date: Tue, 22 Jul 2003 10:12:20 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Tuning PostgreSQL Message-ID: <20030722141219.GA5158@libertyrms.info> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org 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> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <009901c35054$fad824d0$b696a8c0@APR> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/353 X-Sequence-Number: 2646 On Tue, Jul 22, 2003 at 03:27:20PM +0200, Alexander Priem wrote: > file system, mounted with 'noatime'. I will use a UPS, so I don't think I > need the journaling of ext3. XFS is not natively supported by RedHat and I Just in case you're still thinking, why do you suppose that only power failures lead to system crashes? Surprise kernel panics due to bad hardware or OS upgrades with bugs in them, sudden failures because of bad memory, &c: all these things also can lead to crashes, and though super-redundant hardware can mitigate that risk, they can't eliminate them completely. This is not advice, of course, but for my money, its a bad idea not to use a journalled filesystem (or something similar) for production systems. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110