xfs
[Top] [All Lists]

Re: XFS for postgres databases?

To: Net Llama! <netllama@xxxxxxxxxxxxx>
Subject: Re: XFS for postgres databases?
From: "Jeffrey W. Baker" <jwbaker@xxxxxxx>
Date: Thu, 13 May 2004 09:11:35 -0700
Cc: Feizhou <feizhou@xxxxxxxxxxxxx>, stevew@xxxxxxxxxxxxxxx, linux-xfs@xxxxxxxxxxx
In-reply-to: <Pine.LNX.4.55.0405130827580.28868@xxxxxxxxxxxxx>
References: <200405121300.14866.stevew@xxxxxxxxxxxxxxx> <1084332608.11308.3.camel@noodles> <40A22CA8.5090300@xxxxxxxxxxxxx> <Pine.LNX.4.55.0405130827580.28868@xxxxxxxxxxxxx>
Sender: linux-xfs-bounce@xxxxxxxxxxx
On Thu, 2004-05-13 at 05:28, Net Llama! wrote:
> On Wed, 12 May 2004, Feizhou wrote:
> > Jeffrey W. Baker wrote:
> > > On Tue, 2004-05-11 at 18:00, Steve Wray wrote:
> > >
> > >>Hi there,
> > >>I'd just like to know if anyone knows of any issues with running a
> > >>postgres database on an XFS filesystem in Linux?
> > >>
> > >>We did this a few weeks ago and the DB Admin swears that they have been
> > >>seeing problems. I'm not convinced that the problems are XFS related.
> > >
> > >
> > > 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?
> >
> > What's wrong with ext3 full journal? (data=journal)

Postgres is a journalling database, so it's safe on any FS.  I like to
use a journalling FS because it's no fun to fsck several terabytes.

-jwb


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