X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id A9CC9D1C9B3 for ; Fri, 8 Aug 2003 18:53:33 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 69667-01 for ; Fri, 8 Aug 2003 15:52:06 -0300 (ADT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id 644D0D1C922 for ; Fri, 8 Aug 2003 15:53:22 -0300 (ADT) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 19lCMd-0004Bi-00 for ; Fri, 08 Aug 2003 14:53:23 -0400 Received: by dba2 (Postfix, from userid 1019) id 93AE3CF52; Fri, 8 Aug 2003 14:53:23 -0400 (EDT) Date: Fri, 8 Aug 2003 14:53:23 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Perfomance Tuning Message-ID: <20030808185323.GH2967@libertyrms.info> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <3F337B39.5030904@coza.net.za> <200308080940.21517.jgardner@jonathangardner.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200308080940.21517.jgardner@jonathangardner.net> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/155 X-Sequence-Number: 2972 On Fri, Aug 08, 2003 at 09:40:20AM -0700, Jonathan Gardner wrote: > > Redhat puts ext3 on by default. Consider switching to a non-journaling FS > (ext2?) with the partition that holds your data and WAL. I would give you exactly the opposite advice: _never_ use a non-journalling fs for your data and WAL. I suppose if you can afford to lose some transactions, you can do without journalling. Otherwise, you're just borrowing trouble, near as I can tell. A ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110