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 A98F7D1BB7B for ; Wed, 7 Apr 2004 22:31:38 -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 97913-07 for ; Wed, 7 Apr 2004 22:31:40 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 5690CD1D06C for ; Wed, 7 Apr 2004 22:31:36 -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 i381VImA006789; Wed, 7 Apr 2004 21:31:18 -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: <200404072212.i37MCck07003@candle.pha.pa.us> References: <200404072212.i37MCck07003@candle.pha.pa.us> Comments: In-reply-to Bruce Momjian message dated "Wed, 07 Apr 2004 18:12:38 -0400" Date: Wed, 07 Apr 2004 21:31:18 -0400 Message-ID: <6788.1081387878@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/94 X-Sequence-Number: 6394 Bruce Momjian writes: > scott.marlowe wrote: >>> There is no real need (or benefit) from having the database on a >>> journalled filesystem - the journalling is only trying to give similar >>> sorts of guarantees to what the fsync in PostgreSQL is doing. >> >> Is this true? I was under the impression that without at least meta-data >> journaling postgresql could still be corrupted by power failure. > It is false. ext2 isn't crash-safe, and PostgreSQL needs an intact file > system for WAL recovery. 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. regards, tom lane