From: Alex Turner <armtuk@gmail.com>
To: Martin Fandel <martin.fandel@alphyra-evs.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Filesystem
Date: Fri, 3 Jun 2005 09:18:10 -0400
Message-ID: <33c6269f050603061824b0cdbf@mail.gmail.com> (raw)
In-Reply-To: <1117782401.4380.37.camel@fandelm.ecommit.de>
References: <1117782401.4380.37.camel@fandelm.ecommit.de>
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: armtuk@gmail.com, martin.fandel@alphyra-evs.de
Subject: Re: Filesystem
In-Reply-To: <33c6269f050603061824b0cdbf@mail.gmail.com>
* 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