X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 64853D8BF3 for ; Thu, 10 Nov 2005 11:43:14 -0400 (AST) 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 52260-06 for ; Thu, 10 Nov 2005 15:43:10 +0000 (GMT) X-Greylist: delayed 01:00:03.527391 by SQLgrey- Received: from vms046pub.verizon.net (vms046pub.verizon.net [206.46.252.46]) by svr1.postgresql.org (Postfix) with ESMTP id A02F6D89CA for ; Thu, 10 Nov 2005 11:43:11 -0400 (AST) Received: from osgiliath.mathom.us ([70.108.64.202]) by vms046.mailsrvcs.net (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPA id <0IPQ00K7XU7XQQ70@vms046.mailsrvcs.net> for pgsql-performance@postgresql.org; Thu, 10 Nov 2005 08:43:10 -0600 (CST) Received: from localhost (localhost [127.0.0.1]) by osgiliath.mathom.us (Postfix) with ESMTP id 867416001EE for ; Thu, 10 Nov 2005 09:43:09 -0500 (EST) Received: from osgiliath.mathom.us ([127.0.0.1]) by localhost (osgiliath [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 29980-06-3 for ; Thu, 10 Nov 2005 09:43:09 -0500 (EST) Received: by osgiliath.mathom.us (Postfix, from userid 1000) id 6B30E6001E3; Thu, 10 Nov 2005 09:43:09 -0500 (EST) Date: Thu, 10 Nov 2005 09:43:09 -0500 From: Michael Stone Subject: Re: WAL sync behaviour In-reply-to: <20051110142535.GA4530@uio.no> To: pgsql-performance@postgresql.org Mail-Followup-To: pgsql-performance@postgresql.org Message-id: <20051110144309.GO9905@mathom.us> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-disposition: inline X-Pgp-Fingerprint: 53 FF 38 00 E7 DD 0A 9C 84 52 84 C5 EE DF 7C 88 X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at mathom.us References: <20051110133241.GA4031@uio.no> <437355C6.4030604@archonet.com> <20051110142535.GA4530@uio.no> User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.003 required=5 tests=[AWL=0.003] X-Spam-Score: 0.003 X-Spam-Level: X-Archive-Number: 200511/178 X-Sequence-Number: 15435 On Thu, Nov 10, 2005 at 03:25:35PM +0100, Steinar H. Gunderson wrote: >Ah, yes, I forgot -- it's ext3. We're considering simply moving the WAL onto >a separate partition (with data=writeback and noatime) if that can help us >any. There's no reason to use a journaled filesystem for the wal. Use ext2 in preference to ext3. Mike Stone