[Top] [All Lists]

Re: XFS for postgres databases?

To: Feizhou <feizhou@xxxxxxxxxxxxx>
Subject: Re: XFS for postgres databases?
From: Jeremy Jackson <jerj@xxxxxxxxxxxx>
Date: Fri, 04 Jun 2004 15:32:45 -0400
Cc: "Jeffrey W. Baker" <jwbaker@xxxxxxx>, stevew@xxxxxxxxxxxxxxx, linux-xfs@xxxxxxxxxxx
In-reply-to: <40A22CA8.5090300@xxxxxxxxxxxxx>
References: <200405121300.14866.stevew@xxxxxxxxxxxxxxx> <1084332608.11308.3.camel@noodles> <40A22CA8.5090300@xxxxxxxxxxxxx>
Sender: linux-xfs-bounce@xxxxxxxxxxx
User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040122 Debian/1.6-1
Feizhou wrote:
Jeffrey W. Baker wrote:
Until a few days ago I had a very large postgresql installation on XFS. We suffered very unusual problems like corrupt tables, missing rows,
corrupt indexes, and so forth.  We've never seen those problems on ext2,
to which we have since switched back.

Why would you put a database on a meta data journaling only filesystem?

The original poster mentions ext2, which has no journaling.

In the case of ext3, with metadata only journaling, or other metadata only journaling filesystems (XFS for sure, JFS?), you would use postgres because it does all the data journaling (since v7 with WAL).

What's wrong with ext3 full journal? (data=journal)

Hmm.  wonder if that would help mysql :)

Jeremy Jackson
Coplanar Networks

<Prev in Thread] Current Thread [Next in Thread>