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 0B0B8D1D098 for ; Thu, 8 Apr 2004 08:54:30 -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 90672-09 for ; Thu, 8 Apr 2004 08:54:29 -0300 (ADT) Received: from 3times25.net (66-23-202-190.clients.speedfactory.net [66.23.202.190]) by svr1.postgresql.org (Postfix) with ESMTP id 0FA5AD1B441 for ; Thu, 8 Apr 2004 08:54:27 -0300 (ADT) Received: from 3times25.net (localhost [127.0.0.1]) by 3times25.net (Postfix) with ESMTP id 7D5E74C167; Thu, 8 Apr 2004 07:56:53 -0400 (EDT) Message-ID: <40753E05.7030300@3times25.net> Date: Thu, 08 Apr 2004 07:56:53 -0400 From: Geoffrey User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Andrew McMillan Cc: Tom Lane , pgsql-performance@postgresql.org Subject: Re: good pc but bad performance,why? References: <200404080133.i381XYu13325@candle.pha.pa.us> <7294.1081390414@sss.pgh.pa.us> <1081414478.2428.13.camel@lamb.mcmillan.net.nz> In-Reply-To: <1081414478.2428.13.camel@lamb.mcmillan.net.nz> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/107 X-Sequence-Number: 6407 Andrew McMillan wrote: > 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. You can mount ext3 filesystems as ext2 and they will function just as ext2. -- Until later, Geoffrey Registered Linux User #108567 Building secure systems in spite of Microsoft