X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C8A2A475F34 for ; Tue, 1 Apr 2003 12:55:13 -0500 (EST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by postgresql.org (Postfix) with ESMTP id 3F21D475E4D for ; Tue, 1 Apr 2003 12:55:13 -0500 (EST) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 190Pyh-00017A-00 for ; Tue, 01 Apr 2003 12:55:19 -0500 Received: from andrew by dba2 with local (Exim 3.36 #1 (Debian)) id 190Pyh-0002Xm-00 for ; Tue, 01 Apr 2003 12:55:19 -0500 Date: Tue, 1 Apr 2003 12:55:19 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: ext3 filesystem / linux 7.3 Message-ID: <20030401175519.GA9553@mail> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <20030331205544.19785.qmail@web21104.mail.yahoo.com> <08f801c2f874$c6aac3d0$0b02a8c0@pointhere.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <08f801c2f874$c6aac3d0$0b02a8c0@pointhere.net> User-Agent: Mutt/1.5.3i X-Spam-Status: No, hits=-34.8 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,REFERENCES, REPLY_WITH_QUOTES,USER_AGENT_MUTT 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/6 X-Sequence-Number: 1512 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