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 B080CD1D06A for ; Wed, 7 Apr 2004 23:13:39 -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 11913-05 for ; Wed, 7 Apr 2004 23:13:41 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 4D3C3D1C9C8 for ; Wed, 7 Apr 2004 23:13:37 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i382DYcb007295; Wed, 7 Apr 2004 22:13:34 -0400 (EDT) To: Bruce Momjian Cc: "scott.marlowe" , Andrew McMillan , huang yaqin , pgsql-performance@postgresql.org Subject: Re: good pc but bad performance,why? In-reply-to: <200404080133.i381XYu13325@candle.pha.pa.us> References: <200404080133.i381XYu13325@candle.pha.pa.us> Comments: In-reply-to Bruce Momjian message dated "Wed, 07 Apr 2004 21:33:34 -0400" Date: Wed, 07 Apr 2004 22:13:34 -0400 Message-ID: <7294.1081390414@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/96 X-Sequence-Number: 6396 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. regards, tom lane