X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B464F476178 for ; Mon, 7 Apr 2003 13:17:53 -0400 (EDT) Received: from localhost.localdomain (unknown [65.217.53.66]) by postgresql.org (Postfix) with ESMTP id C60CD475FBA for ; Mon, 7 Apr 2003 13:17:44 -0400 (EDT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by localhost.localdomain (8.12.8/8.12.5) with ESMTP id h37Htakj000670; Mon, 7 Apr 2003 13:55:36 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id h37HHZx29153; Mon, 7 Apr 2003 13:17:35 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id F3HTM18W; Mon, 7 Apr 2003 13:17:35 -0400 Subject: Re: ext3 filesystem / linux 7.3 From: Robert Treat To: Shankar K Cc: "scott.marlowe" , Chris Sutton , pgsql-performance@postgresql.org In-Reply-To: <20030403194552.914.qmail@web21103.mail.yahoo.com> References: <20030403194552.914.qmail@web21103.mail.yahoo.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 07 Apr 2003 13:17:35 -0400 Message-Id: <1049735855.8344.8807.camel@camel> Mime-Version: 1.0 X-Spam-Status: No, hits=-35.6 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,REFERENCES, REPLY_WITH_QUOTES,USER_AGENT_XIMIAN 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/71 X-Sequence-Number: 1577 We've had 2 crashes on red hat 7.3 in about 9 months of running. Both instances required manual power off/on of the server, but everything came up nice and ready to go. The problems seemed to stem from i/o load with the kernel (not postgresql specific), but should be resolved with the latest Red Hat kernel. If you search on buffer_jdirty in bugzilla you'll see a couple of reports. Robert Treat On Thu, 2003-04-03 at 14:45, Shankar K wrote: > Hi Scott, > > Could you please share with us the problems you had > with linux 7.3 > > would be really interested to know the kernel configs > and ext3 filesystem modes > > Shankar > > --- "scott.marlowe" wrote: > > On Thu, 3 Apr 2003, Chris Sutton wrote: > > > > > On Wed, 2 Apr 2003, Josh Berkus wrote: > > > > > > > > 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. > > > > > > We recently started using Postgres on a new > > database server running RH 7.3 > > > and ext3. Due to some kernel problems the machine > > would crash at random > > > times. Each time it crashed it came back up > > extremly easily with no data > > > loss. If we were on ext2 coming back up after a > > crash probably wouldn't > > > have been quite as easy. > > > > > > We have since given up on RH 7.3 and gone with RH > > Enterprise ES. Just an > > > FIY for any of you out there thinking about moving > > to RH 7.3 or those that > > > are having problems with 7.3 and ext3. > > > > We're still running RH 7.2 due to issues we had with > > 7.3 as well. > >