X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 2A254D1B561 for ; Tue, 12 Aug 2003 05:08:20 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 17499-07 for ; Tue, 12 Aug 2003 02:06:48 -0300 (ADT) Received: from home.samurai.com (home.samurai.com [205.207.28.66]) by svr1.postgresql.org (Postfix) with ESMTP id 4DB53D1B550 for ; Tue, 12 Aug 2003 02:08:09 -0300 (ADT) Received: by home.samurai.com (Postfix, from userid 1014) id 271E326203; Tue, 12 Aug 2003 01:08:09 -0400 (EDT) Date: Tue, 12 Aug 2003 01:08:09 -0400 From: Neil Conway To: Bruce Momjian Cc: Reece Hart , "pgsql-performance@postgresql.org" Subject: Re: Perfomance Tuning Message-ID: <20030812050809.GC76772@home.samurai.com> References: <20030812043719.GB76772@home.samurai.com> <200308120452.h7C4qkH14615@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200308120452.h7C4qkH14615@candle.pha.pa.us> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/198 X-Sequence-Number: 3015 On Tue, Aug 12, 2003 at 12:52:46AM -0400, Bruce Momjian wrote: I don't use Linux and was just repeating what I had heard from others, > and read in postings. I don't have any first-hand experience with ext2 > (except for a laptop I borrowed that wouldn't boot after being shut > off), but others on this mailing list have said the same thing. Right, and I understand the need to answer users asking about which filesystem to use, but I'd be cautious of bad-mouthing another OSS project without any hard evidence to back up our claim (of course if we have such evidence, then fine -- I just haven't seen it). It would be like $SOME_LARGE_OSS project saying "Don't use our project with PostgreSQL, as foo@bar.org had data corruption with PostgreSQL 6.3 on UnixWare" -- kind of annoying, right? > > (a) ext3 does metadata-only journalling by default > > If that is true, why was I told people have to mount their ext3 file > systems with metadata-only. Again, I have no experience myself, but why > are people telling me this? Perhaps they were suggesting that people mount ext2 using data=writeback, rather than the default of data=ordered. BTW, I've heard from a couple different people that using ext3 with data=journalled (i.e. enabling journalling of both data and metadata) actually makes PostgreSQL faster, as it means that ext3 can skip PostgreSQL's fsync request since ext3's log is flushed to disk already. I haven't tested this myself, however. -Neil