X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 108394762A2 for ; Wed, 2 Apr 2003 19:23:06 -0500 (EST) Received: from localhost.localdomain (208-41-234-242.client.dsl.net [208.41.234.242]) by postgresql.org (Postfix) with ESMTP id BF2A24762D7 for ; Wed, 2 Apr 2003 19:23:04 -0500 (EST) Received: from endeavour (endeavour.pointhere.net [192.168.2.11]) by localhost.localdomain (8.11.6/8.11.6) with SMTP id h330CE906997; Wed, 2 Apr 2003 19:12:14 -0500 Message-ID: <0a8001c2f978$28959a80$0b02a8c0@pointhere.net> Reply-To: "Jeffrey D. Brower" From: "Jeffrey D. Brower" To: , "Andreas Kostyrka" Cc: "Bruce Momjian" , , "Shankar K" , "eric soroos" References: <26287373.1162931668@[4.42.179.151]> <1049298455.21669.333.camel@andi-lap> <0a6f01c2f93a$6907bf50$0b02a8c0@pointhere.net> <200304021205.30075.josh@agliodbs.com> Subject: Re: ext3 filesystem / linux 7.3 Date: Wed, 2 Apr 2003 19:29:57 -0500 Organization: A Basic Marketing Company MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Spam-Status: No, hits=-16.9 required=5.0 tests=BAYES_20,MAILTO_TO_SPAM_ADDR,ORIGINAL_MESSAGE, QUOTED_EMAIL_TEXT,RCVD_IN_NJABL,REFERENCES, X_NJABL_OPEN_PROXY autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/24 X-Sequence-Number: 1530 Thanks for that Josh. I had previously understood that ext3 was a bad thing with PostgreSQL and I went way above and beyond to create it on an Ext2 filesystem (the only one on the server) and mount that. Should I undo that work and go back to Ext3? Jeff ----- Original Message ----- From: "Josh Berkus" To: "Jeffrey D. Brower" ; "Andreas Kostyrka" Cc: "Bruce Momjian" ; ; "Shankar K" ; "eric soroos" Sent: Wednesday, April 02, 2003 3:05 PM Subject: Re: [PERFORM] ext3 filesystem / linux 7.3 > Jeff, > > > How all of that works WITH and/or AGAINST PostgreSQL and what metadata > > REALLY means is my bottom line quandary. Obviously that is where finding > > the warm and fuzzy place between speed and safety is found. > > For your $PGDATA directory, your only need for filesystem journaling is to > prevent a painful fsck process on an unexpected power-out. You are not, as a > rule, terribly concerned with journaling the data as PostgreSQL already > provides some data recovery protection through WAL. > > As a result, on my one server where I have to use Ext3 (I use Reiser on most > machines, and have never had a problem except for one disaster when upgrading > Reiser versions), the $PGDATA is mounted "noatime,data=writeback" > > (BTW, I found that combining "data=writeback" with Linux LVM on RedHat 8.0 > resulted in system-fatal mounting errors. Anyone else have this problem?) > > Of course, if you have a machine with a $60,000 disk array and disk I/O is > unlimited, then maybe you want to enable data=journal just for the protection > against corruption of the WAL and clog files. > > -- > -Josh Berkus > Aglio Database Solutions > San Francisco