X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id B9A8CD1C9F0 for ; Wed, 6 Aug 2003 21:50:30 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 85591-05 for ; Wed, 6 Aug 2003 18:49:09 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id DB216D1C9C8 for ; Wed, 6 Aug 2003 18:50:18 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h76LoJSa009183; Wed, 6 Aug 2003 17:50:19 -0400 (EDT) To: Roberto Mello Cc: pgsql-sql@postgresql.org Subject: Re: PostgreSQL and Journaled File Systems In-reply-to: <20030806211645.GH18121@cc.usu.edu> References: <20030806211645.GH18121@cc.usu.edu> Comments: In-reply-to Roberto Mello message dated "Wed, 06 Aug 2003 15:16:45 -0600" Date: Wed, 06 Aug 2003 17:50:19 -0400 Message-ID: <9182.1060206619@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/60 X-Sequence-Number: 14676 Roberto Mello writes: > What is the word about using PG with journaled file systems? I have heard > that it's best to not have the PG journal in a journaled system to avoid > double journaling. Journaling metadata is good. Journaling file contents is redundant --- turn that off if you can. (Of course, if there is anything other than Postgres files on the same device, you may not want to turn off contents journalling...) regards, tom lane