X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5A0BBD1BAF7 for ; Thu, 8 Apr 2004 05:54:49 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 33130-06 for ; Thu, 8 Apr 2004 05:54:47 -0300 (ADT) Received: from lamb.mcmillan.net.nz (218-101-13-8.paradise.net.nz [218.101.13.8]) by svr1.postgresql.org (Postfix) with ESMTP id B8020D1BAAD for ; Thu, 8 Apr 2004 05:54:45 -0300 (ADT) Received: from lamb.mcmillan.net.nz (lamb.mcmillan.net.nz [127.0.0.1]) by lamb.mcmillan.net.nz (Postfix) with ESMTP id D2DCDAD98581; Thu, 8 Apr 2004 20:54:39 +1200 (NZST) Subject: Re: good pc but bad performance,why? From: Andrew McMillan To: Tom Lane Cc: pgsql-performance@postgresql.org In-Reply-To: <7294.1081390414@sss.pgh.pa.us> References: <200404080133.i381XYu13325@candle.pha.pa.us> <7294.1081390414@sss.pgh.pa.us> Content-Type: text/plain Message-Id: <1081414478.2428.13.camel@lamb.mcmillan.net.nz> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Thu, 08 Apr 2004 20:54:39 +1200 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/100 X-Sequence-Number: 6400 On Thu, 2004-04-08 at 14:13, Tom Lane wrote: > Bruce Momjian writes: > > Tom Lane wrote: > >> But it should be okay to set the filesystem to journal only its own > >> metadata. There's no need for it to journal file contents. > > > Can you set ext2 to journal metadata? I didn't know it could do that. > > No, ext2 has no journal at all AFAIK. But I believe ext3 has an option > to journal or not journal file contents, and at least on a Postgres-only > volume you'd want to turn that off. No, it certainly doesn't. To be honest I was not aware that PostgreSQL was susceptible to failure on non[metadata] journalled filesystems - I was [somewhat vaguely] of the understanding that it would work fine on any filesystem. And obviously, from my original post, we can see that I believed metadata journalling was wasted on it. Is the 'noatime' option worthwhile? Are you saying that PostgreSQL should always be run on a metadata journalled filesystem then, and that VFAT, ext2, etc are ++ungood? Thanks, Andrew McMillan. ------------------------------------------------------------------------- Andrew @ Catalyst .Net .NZ Ltd, PO Box 11-053, Manners St, Wellington WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St DDI: +64(4)916-7201 MOB: +64(21)635-694 OFFICE: +64(4)499-2267 A foolish consistency is the hobgoblin of little minds - Shaw -------------------------------------------------------------------------