[Top] [All Lists]

Re: XFS for postgres databases?

To: linux-xfs@xxxxxxxxxxx
Subject: Re: XFS for postgres databases?
From: Steve Wray <stevew@xxxxxxxxxxxxxxx>
Date: Thu, 13 May 2004 08:42:20 +1200
In-reply-to: <20040512143941.A389759@xxxxxxxxxxxxxxxxxxxxxxxx>
References: <200405121300.14866.stevew@xxxxxxxxxxxxxxx> <1084332608.11308.3.camel@noodles> <20040512143941.A389759@xxxxxxxxxxxxxxxxxxxxxxxx>
Reply-to: stevew@xxxxxxxxxxxxxxx
Sender: linux-xfs-bounce@xxxxxxxxxxx
User-agent: KMail/1.6.1
On Wednesday 12 May 2004 16:39, Nathan Scott wrote:
> On Tue, May 11, 2004 at 08:30:08PM -0700, 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.
> You were running dd on the block device at the same time as using
> the mounted filesystem though, weren't you?  Did problems persist
> after you stopped doing that?  You didn't get back to us with any
> further details there..
> Do you (either of you) have a test case so we can try to reproduce
> these problems locally?

Unfortunately this was on the database of a very sensitive client so we 
have scrubbed XFS and reverted to ext2. So I can't reproduce the 
problem at all. I'll have a chat with the database developers and 
admins and see if we can construct a test case on a development box.

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