X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id AC51C475AF8 for ; Tue, 1 Apr 2003 15:43:36 -0500 (EST) Received: from hal.istation.com (hal.istation.com [65.120.151.132]) by postgresql.org (Postfix) with ESMTP id D1E7247592C for ; Tue, 1 Apr 2003 15:43:35 -0500 (EST) Received: from sauron (sauron.istation.com [65.120.151.174]) (authenticated) by hal.istation.com (8.11.6/8.11.6) with ESMTP id h31KhXK03610; Tue, 1 Apr 2003 14:43:33 -0600 Reply-To: From: "Keith Bottner" To: "'Andrew Sullivan'" , Subject: Re: ext3 filesystem / linux 7.3 Date: Tue, 1 Apr 2003 14:43:35 -0600 Organization: istation.com Message-ID: <000a01c2f88f$5e288200$ae977841@istation.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.3416 In-reply-to: <20030401175519.GA9553@mail> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal X-Spam-Status: No, hits=-37.3 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,ORIGINAL_MESSAGE, QUOTED_EMAIL_TEXT,REPLY_WITH_QUOTES,SIGNATURE_LONG_SPARSE autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/11 X-Sequence-Number: 1517 FYI, I believe that XFS will be included in the 2.6 kernel. Keith Bottner kbottner@istation.com -----Original Message----- From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Andrew Sullivan Sent: Tuesday, April 01, 2003 11:55 AM To: pgsql-performance@postgresql.org Subject: Re: [PERFORM] ext3 filesystem / linux 7.3 On Tue, Apr 01, 2003 at 12:33:15PM -0500, Jeffrey D. Brower wrote: > What is the URL of that article? I understood that ext2 was faster > with PG and so I went to a lot of trouble of creating an ext2 > partition just for PG and gave up the journalling to do that. > Something about double effort since PG already does a lot of that. I don't know how ext3 could be faster than ext2, since it has to do more work. But ext2 is not crash-safe. So your data could well be hosed if you come back from a crash on ext2. Actually, I have my doubts about _any_ of the journaling filesystems for Linux: ext3 has a reputation for being slow if you journal in the real-safe mode, and there have been so many unrepeatable reiserfs problem reports that I'm loathe to use it for real systems. I had exceptionally good experiences with xfs when I was admining SGI boxes, but that's not part of the standard Linux kernel distribution, and with no idea why, I think my managers would get grumpy with me for using it. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org