Re: Filesystem

From: "Martin Fandel" <martin(dot)fandel(at)alphyra-evs(dot)de>
To: Alex Turner <armtuk(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Filesystem
Date: 2005-06-03 13:52:00
Message-ID: 1117806720.4380.129.camel@fandelm.ecommit.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi

i have tested a xfs+LVM installation with the scalix (HP OpenMail)
Mailserver (it's a little time ago). I had at that time some problems
using xfs_freeze. I used a script for freezing the fs and making storing
the snapshots. Sometimes the complete Server hangs (no blinking cursor,
no possible logins, no network). I don't know if it was a hardware
problem or if it was the xfs-software. I installed/compiled the newest
kernel for this system (i think it was a 2.6.9) to check out if it's
maybe a kernel-problem. But on the next days, the system hangs
again. After that i used reiserfs again.

I tested it with Suse Linux Enterprise Server 8.

Has someone heared about such problems? That is the only reason that
i have a bit fear to use xfs for a critical database :/.

Best regards,
Martin

Am Freitag, den 03.06.2005, 09:18 -0400 schrieb Alex Turner:
> We have been using XFS for about 6 months now and it has even
> tolerated a controller card crash. So far we have mostly good things
> to report about XFS. I benchmarked raw throughputs at various stripe
> sizes, and XFS came out on top for us against reiser and ext3. I also
> used it because of it's supposed good support for large files, which
> was verified somewhat by the benchmarks.
>
> I have noticed a problem though - if you have 800000 files in a
> directory, it seems that XFS chokes on simple operations like 'ls' or
> 'chmod -R ...' where ext3 doesn't, don't know about reiser, I went
> straight back to default after that problem (that partition is not on
> a DB server though).
>
> Alex Turner
> netEconomist
>
> On 6/3/05, Martin Fandel <martin(dot)fandel(at)alphyra-evs(dot)de> wrote:
> Hi @ all,
>
> i have only a little question. Which filesystem is preferred
> for
> postgresql? I'm plan to use xfs (before i used reiserfs). The
> reason
> is the xfs_freeze Tool to make filesystem-snapshots.
>
> Is the performance better than reiserfs, is it reliable?
>
> best regards,
> Martin
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an
> appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so
> that your
> message can get through to the mailing list cleanly
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message philb 2005-06-03 14:24:02 Re: Query plan for very large number of joins
Previous Message Stephen Frost 2005-06-03 13:27:20 Re: Query limitations (size, number of UNIONs ...)