X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 7A4189DC9B2 for ; Tue, 21 Mar 2006 08:01:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 54415-07 for ; Tue, 21 Mar 2006 08:02:00 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 044539DC885 for ; Tue, 21 Mar 2006 08:01:55 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 7AD4556435; Tue, 21 Mar 2006 06:01:59 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Tue, 21 Mar 2006 06:01:58 -0600 Date: Tue, 21 Mar 2006 06:01:58 -0600 From: "Jim C. Nasby" To: Csaba Nagy , Mikael Carneholm , postgres performance list Subject: Re: Migration study, step 1: bulk write performance Message-ID: <20060321120158.GO15742@pervasive.com> References: <7F10D26ECFA1FB458B89C5B4B0D72C2B088286@sesrv12.wirelesscar.com> <1142867952.16487.96.camel@coppola.muc.ecircle.de> <20060321112759.GF15742@pervasive.com> <1142941966.23597.4.camel@coppola.muc.ecircle.de> <20060321115618.GA12880@uio.no> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060321115618.GA12880@uio.no> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060321:nagy@ecircle-ag.com::TyYLunnBZCV4AmHW:000000000000000000 0000000000000000000000001Bqx X-Hashcash: 1:20:060321:mikael.carneholm@wirelesscar.com::r8zN8+oLN72AiQQO:00000 0000000000000000000000002MwL X-Hashcash: 1:20:060321:pgsql-performance@postgresql.org::pMH1afqDAqA6YuxV:00000 0000000000000000000000002Y7u X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.108 required=5 tests=[AWL=0.108] X-Spam-Score: 0.108 X-Spam-Level: X-Archive-Number: 200603/390 X-Sequence-Number: 17827 On Tue, Mar 21, 2006 at 12:56:18PM +0100, Steinar H. Gunderson wrote: > On Tue, Mar 21, 2006 at 12:52:46PM +0100, Csaba Nagy wrote: > > They knew however that for the data partitions no FS journaling is > > needed, and for the WAL partition meta data journaling is enough, so I > > guess they tuned ext3 for this. > > For the record, that's the wrong way round. For the data partitioning > metadata journaling is enough, and for the WAL partition you don't need any > FS journaling at all. Are you sure? Metadate changes are probably a lot more common on the WAL partition. In any case, I don't see why there should be a difference. The real issue is: is related filesystem metadata sync'd as part of a file being fsync'd? -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461