From: Martin Fandel <martin.fandel@alphyra-evs.de>
To: Alex Turner <armtuk@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Filesystem
Date: Fri, 3 Jun 2005 15:52:00 +0200
Message-ID: <1117806720.4380.129.camel@fandelm.ecommit.de> (raw)
In-Reply-To: <33c6269f050603061824b0cdbf@mail.gmail.com>
References: <1117782401.4380.37.camel@fandelm.ecommit.de>
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.fandel@alphyra-evs.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@postgresql.org so
> that your
> message can get through to the mailing list cleanly
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: martin.fandel@alphyra-evs.de, armtuk@gmail.com
Subject: Re: Filesystem
In-Reply-To: <1117806720.4380.129.camel@fandelm.ecommit.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox