Re: Filesystem - Mailing list pgsql-performance

From Alex Turner
Subject Re: Filesystem
Date
Msg-id 33c6269f050603061824b0cdbf@mail.gmail.com
Whole thread Raw
In response to Filesystem  ("Martin Fandel" <martin.fandel@alphyra-evs.de>)
Responses Re: Filesystem  ("Martin Fandel" <martin.fandel@alphyra-evs.de>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query plan for very large number of joins
Next
From: Stephen Frost
Date:
Subject: Re: Query limitations (size, number of UNIONs ...)