X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8749E475CBC for ; Tue, 1 Apr 2003 13:26:13 -0500 (EST) Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251]) by postgresql.org (Postfix) with ESMTP id 34DF4475AF8 for ; Tue, 1 Apr 2003 13:26:12 -0500 (EST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id h31IQ2S29201; Tue, 1 Apr 2003 13:26:02 -0500 (EST) From: Bruce Momjian Message-Id: <200304011826.h31IQ2S29201@candle.pha.pa.us> Subject: Re: ext3 filesystem / linux 7.3 In-Reply-To: <26287373.1162931668@[4.42.179.151]> To: eric soroos Date: Tue, 1 Apr 2003 13:26:02 -0500 (EST) Cc: Shankar K , pgsql-performance@postgresql.org, "Jeffrey D.Brower" X-Mailer: ELM [version 2.4ME+ PL99 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Spam-Status: No, hits=-25.4 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,MAILTO_TO_SPAM_ADDR, QUOTED_EMAIL_TEXT,REPLY_WITH_QUOTES 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/7 X-Sequence-Number: 1513 eric soroos wrote: > On Tue, 1 Apr 2003 09:39:17 -0800 (PST) in message > <20030401173917.19476.qmail@web21101.mail.yahoo.com>, Shankar > K wrote: > > hi jeff, > > > > go to > > http://www.ca.postgresql.org/docs/momjian/hw_performance/ > > under 'filesystems' slide. > > > > I suspect that is what he's seen. > > >From my experience, ext3 is only a percent or two slower than ext2 under pg_bench. It saves an amazing amount of time on startup after a failure by not having to fsck to confirm that the filesystem is in a consistent state. > > I believe that ext3 is a metadata journaling system, and not a > data journaling system. This would indicate that the PG > transactioning is complimentary to the filesystem journaling, > not duplication. Ext3 is only metadata journaling if you set the mount flags as described. I also don't think pgbench is the best test for testing file system performance. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073