X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D135F9FB1FB for ; Tue, 15 Aug 2006 14:27:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 76531-02 for ; Tue, 15 Aug 2006 14:27:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from vms046pub.verizon.net (vms046pub.verizon.net [206.46.252.46]) by postgresql.org (Postfix) with ESMTP id 090069FB270 for ; Tue, 15 Aug 2006 14:27:14 -0300 (ADT) Received: from osgiliath.mathom.us ([72.66.19.42]) by vms046.mailsrvcs.net (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPA id <0J4100DQEV4PZ5F0@vms046.mailsrvcs.net> for pgsql-performance@postgresql.org; Tue, 15 Aug 2006 12:26:50 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by osgiliath.mathom.us (Postfix) with ESMTP id 61BE56FBD1; Tue, 15 Aug 2006 13:26:49 -0400 (EDT) Received: from osgiliath.mathom.us ([127.0.0.1]) by localhost (osgiliath.home.mathom.us [127.0.0.1]) (amavisd-new, port 10024) with LMTP id m9iPmXkCeR0N; Tue, 15 Aug 2006 13:26:47 -0400 (EDT) Received: by osgiliath.mathom.us (Postfix, from userid 1000) id 472AA6FC68; Tue, 15 Aug 2006 13:26:47 -0400 (EDT) Date: Tue, 15 Aug 2006 13:26:46 -0400 From: Michael Stone Subject: Re: Postgresql Performance on an HP DL385 and In-reply-to: <20060815162926.GS27928@pervasive.com> To: "Jim C. Nasby" Cc: pgsql-performance@postgresql.org Mail-followup-to: "Jim C. Nasby" , pgsql-performance@postgresql.org Message-id: <20060815172645.GU2900@mathom.us> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-disposition: inline X-Virus-Scanned: Debian amavisd-new at mathom.us X-Pgp-Fingerprint: 53 FF 38 00 E7 DD 0A 9C 84 52 84 C5 EE DF 7C 88 References: <3E37B936B592014B978C4415F90D662D03FFEF6E@MI8NYCMAIL06.Mi8.com> <721b21dc0608082245u6ee62e7dg522ff18e4d72683@mail.gmail.com> <20060809210539.GR40481@pervasive.com> <1155180553.13315.0.camel@amd64-gentoo-laptop> <20060810110935.GF2900@mathom.us> <20060814153841.GF27928@pervasive.com> <721b21dc0608140851v2332cdf9g59808004c983540f@mail.gmail.com> <20060814170545.GG27928@pervasive.com> <20060814170902.GN2900@mathom.us> <20060815162926.GS27928@pervasive.com> User-Agent: Mutt/1.5.12-2006-07-14 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.759 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/231 X-Sequence-Number: 20416 On Tue, Aug 15, 2006 at 11:29:26AM -0500, Jim C. Nasby wrote: >Are 'we' sure that such a setup can't lose any data? Yes. If you check the archives, you can even find the last time this was discussed... The bottom line is that the only reason you need a metadata journalling filesystem is to save the fsck time when you come up. On a little partition like xlog, that's not an issue. Mike Stone