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 C7C0ED1C92B for ; Wed, 6 Aug 2003 21:16:55 +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 83269-01 for ; Wed, 6 Aug 2003 18:15:34 -0300 (ADT) Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.227.103]) by svr1.postgresql.org (Postfix) with ESMTP id 5E553D1C4EC for ; Wed, 6 Aug 2003 18:16:44 -0300 (ADT) Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian)) id 19kVeH-0004oA-00 for ; Wed, 06 Aug 2003 15:16:45 -0600 Date: Wed, 6 Aug 2003 15:16:45 -0600 From: Roberto Mello To: pgsql-sql@postgresql.org Subject: PostgreSQL and Journaled File Systems Message-ID: <20030806211645.GH18121@cc.usu.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline User-Agent: Mutt/1.4i X-message-flag: Please consider using an e-mail program other than Outlook. It's insecure. X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/58 X-Sequence-Number: 14674 Hi All, 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. Can someone that understand the issues involved (performance, reliability) please shed some light on the issue? Thanks in advance, -Roberto -- +----| Roberto Mello - http://www.brasileiro.net/ |------+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + If I only had a nickel for every time Windows crashed ...