xfs
[Top] [All Lists]

Re: XFS for postgres databases?

To: Feizhou <feizhou@xxxxxxxxxxxxx>
Subject: Re: XFS for postgres databases?
From: Net Llama! <netllama@xxxxxxxxxxxxx>
Date: Thu, 13 May 2004 08:28:08 -0400 (EDT)
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
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)

Its ext3  :)

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Lonni J Friedman                                netllama@xxxxxxxxxxxxx
Linux Step-by-step & TyGeMo                  http://netllama.ipfox.com


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