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 308189DC885 for ; Tue, 21 Mar 2006 07:55:41 -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 53250-08 for ; Tue, 21 Mar 2006 07:55:43 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from cassarossa.samfundet.no (cassarossa.samfundet.no [129.241.93.19]) by postgresql.org (Postfix) with ESMTP id BED5E9DC8DB for ; Tue, 21 Mar 2006 07:55:38 -0400 (AST) Received: from trofast.sesse.net ([129.241.93.32]) by cassarossa.samfundet.no with esmtp (Exim 4.50) id 1FLfSc-0001MX-Rf; Tue, 21 Mar 2006 12:55:39 +0100 Received: from sesse by trofast.sesse.net with local (Exim 3.36 #1 (Debian)) id 1FLfTG-0003MF-00; Tue, 21 Mar 2006 12:56:18 +0100 Date: Tue, 21 Mar 2006 12:56:18 +0100 From: "Steinar H. Gunderson" To: Csaba Nagy Cc: Mikael Carneholm , postgres performance list Subject: Re: Migration study, step 1: bulk write performance Message-ID: <20060321115618.GA12880@uio.no> Mail-Followup-To: Csaba Nagy , Mikael Carneholm , postgres performance list 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> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <1142941966.23597.4.camel@coppola.muc.ecircle.de> X-Operating-System: Linux 2.6.14.3 on a x86_64 X-Message-Flag: Outlook? --> http://www.mozilla.org/products/thunderbird/ User-Agent: Mutt/1.5.11+cvs20060126 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.085 required=5 tests=[AWL=0.085] X-Spam-Score: 0.085 X-Spam-Level: X-Archive-Number: 200603/387 X-Sequence-Number: 17824 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. /* Steinar */ -- Homepage: http://www.sesse.net/