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 EB2E3D1C4DB for ; Fri, 8 Aug 2003 19:57:07 +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 71445-07 for ; Fri, 8 Aug 2003 16:55:41 -0300 (ADT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id F1A7CD1C4CA for ; Fri, 8 Aug 2003 16:56:56 -0300 (ADT) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 19lDMA-0005nw-00 for ; Fri, 08 Aug 2003 15:56:58 -0400 Received: by dba2 (Postfix, from userid 1019) id A624BCF52; Fri, 8 Aug 2003 15:56:58 -0400 (EDT) Date: Fri, 8 Aug 2003 15:56:58 -0400 From: Andrew Sullivan To: Postgresql Performance Subject: Re: Perfomance Tuning Message-ID: <20030808195658.GJ2967@libertyrms.info> Mail-Followup-To: Andrew Sullivan , Postgresql Performance References: <1060370026.97914.40.camel@jester> <200308081934.h78JYi906553@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200308081934.h78JYi906553@candle.pha.pa.us> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/159 X-Sequence-Number: 2976 On Fri, Aug 08, 2003 at 03:34:44PM -0400, Bruce Momjian wrote: > > It is true that ext2 isn't good because the file system may not recover, > but BSD UFS isn't a journalled file system, but does guarantee file > system recovery after a crash --- it is especially good using soft > updates. Sorry. I usually write "journalled or equivalent" for this reason. I think UFS with soft updates is a good example of this. You also don't need complete journalling in most cases -- metadata is probably sufficient, given fsync. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110