X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 942F232A17C for ; Thu, 21 Oct 2004 15:21:11 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 32287-05 for ; Thu, 21 Oct 2004 14:21:05 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id C780332A11C for ; Thu, 21 Oct 2004 15:21:05 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id i9LEKtIM015150; Thu, 21 Oct 2004 10:20:55 -0400 (EDT) To: "Steinar H. Gunderson" Cc: pgsql-performance@postgresql.org Subject: Re: Anything to be gained from a 'Postgres Filesystem'? In-reply-to: <20041021134506.GA1667@uio.no> References: <20041021134506.GA1667@uio.no> Comments: In-reply-to "Steinar H. Gunderson" message dated "Thu, 21 Oct 2004 15:45:06 +0200" Date: Thu, 21 Oct 2004 10:20:55 -0400 Message-ID: <15149.1098368455@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/351 X-Sequence-Number: 8827 "Steinar H. Gunderson" writes: > ... I have no idea how much you can improve over the "best" > filesystems out there, but having two layers of journalling (both WAL _and_ > FS journalling) on top of each other don't make all that much sense to me. Which is why setting the FS to journal metadata but not file contents is often suggested as best practice for a PG-only filesystem. regards, tom lane