From: "J. Andrew Rogers" <jrogers@neopolitan.com>
Subject: Re: Filesystem
To: "Martin Fandel" <martin.fandel@alphyra-evs.de>,
	pgsql-performance@postgresql.org
Date: Fri, 03 Jun 2005 10:18:45 -0700
Message-ID: <web-9626787@mx1.neopolitan.us>
In-Reply-To: <1117782401.4380.37.camel@fandelm.ecommit.de>
References: <1117782401.4380.37.camel@fandelm.ecommit.de>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"; format="flowed"
Content-Transfer-Encoding: 8bit

On Fri, 3 Jun 2005 09:06:41 +0200
  "Martin Fandel" <martin.fandel@alphyra-evs.de> wrote:
> 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. 


XFS has worked great for us, and has been both reliable 
and fast.  Zero problems and currently our standard server 
filesystem.  Reiser, on the other hand, has on rare 
occasion eaten itself on the few systems where someone was 
running a Reiser partition, though none were running 
Postgres at the time.  We have deprecated the use of 
Reiser on all systems where it is not already running.

In terms of performance for Postgres, the rumor is that 
XFS and JFS are at the top of the heap, definitely better 
than ext3 and somewhat better than Reiser.  I've never 
used JFS, but I've seen a few benchmarks that suggest it 
is at least as fast as XFS for Postgres.

Since XFS is more mature than JFS on Linux, I go with XFS 
by default.  If some tragically bad problems develop with 
XFS I may reconsider that position, but we've been very 
happy with it so far.  YMMV.

cheers,

J. Andrew Rogers