Re: PostgreSQL on XFS experiences?

From: Holger Marzen <holger(at)marzen(dot)de>
To: "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL on XFS experiences?
Date: 2004-02-26 19:46:22
Message-ID: Pine.LNX.4.58.0402262044190.15548@bluebell.marzen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 26 Feb 2004, Jeffrey W. Baker wrote:

> We are using PostgreSQL with the database and xlogs on (separate) XFS
> volumes under Linux 2.4.25. We are simply curious to hear your
> experiences with this combination, if you are using it. In only two
> days of heavy activity, we've already been able to corrupt one
> database. We've also seen XFS panic because of inconsistent in-memory
> metadata. Frankly we don't have the highest confidence.

I am afraid that xfs in that kernel or your hardware is buggy (probably
RAM). A 24h run of memtest86 wouldn't be bad.

Since PostgreSQL uses the operating system's calls for file operations
as any other program does, it's most probably no PostgreSQL issue.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeffrey W. Baker 2004-02-26 20:09:21 Re: PostgreSQL on XFS experiences?
Previous Message Jeffrey W. Baker 2004-02-26 18:56:14 PostgreSQL on XFS experiences?