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 C09213A3E5A for ; Mon, 8 Nov 2004 16:30:39 +0000 (GMT) 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 34639-10 for ; Mon, 8 Nov 2004 16:30:22 +0000 (GMT) Received: from mail.osdl.org (fw.osdl.org [65.172.181.6]) by svr1.postgresql.org (Postfix) with ESMTP id BF6B63A3F0C for ; Mon, 8 Nov 2004 16:30:18 +0000 (GMT) Received: (from markw@localhost) by mail.osdl.org (8.11.6/8.11.6) id iA8GTxN05745; Mon, 8 Nov 2004 08:29:59 -0800 Date: Mon, 8 Nov 2004 08:29:59 -0800 From: Mark Wong To: Dawid Kuroczko Cc: pgsql-performance@postgresql.org Subject: Re: ext3 journalling type Message-ID: <20041108082959.A3950@osdl.org> References: <758d5e7f04110804263efdf475@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <758d5e7f04110804263efdf475@mail.gmail.com>; from qnex42@gmail.com on Mon, Nov 08, 2004 at 01:26:09PM +0100 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: 200411/142 X-Sequence-Number: 9096 I have some data here, no detailed analyses though: http://www.osdl.org/projects/dbt2dev/results/fs/ Mark On Mon, Nov 08, 2004 at 01:26:09PM +0100, Dawid Kuroczko wrote: > The ext3fs allows to selet type of journalling to be used with > filesystem. Journalling pretty much "mirrors" the work of WAL > logging by PostgreSQL... I wonder which type of journalling > is best for PgSQL in terms of performance. > Choices include: > journal > All data is committed into the journal prior to being > written into the main file system. > ordered > This is the default mode. All data is forced directly > out to the main file system prior to its metadata being > committed to the journal. > writeback > Data ordering is not preserved - data may be written into > the main file system after its metadata has been commit- > ted to the journal. This is rumoured to be the highest- > throughput option. It guarantees internal file system > integrity, however it can allow old data to appear in > files after a crash and journal recovery. > > Am I right to assume that "writeback" is both fastest and at the same > time as safe to use as ordered? Maybe any of you did some benchmarks? > > Regards, > Dawid >