From: Jaume Sabater <jsabater@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: postgresql and xfs filesystrem
Date: Mon, 26 Jan 2009 08:34:15 +0100
Message-ID: <3786f7bb0901252334oe0f1f90n3e1ea0a539949733@mail.gmail.com> (raw)
In-Reply-To: <200901260114.38476@zmi.at>
References: <eb90f15e0901251047k6b8bacfm9fdf0d9e4aa9155a@mail.gmail.com>
<d6d6637f0901251106s2e79467m1fe66b692a383508@mail.gmail.com>
<200901260114.38476@zmi.at>
On Mon, Jan 26, 2009 at 1:14 AM, Michael Monnerie
<michael.monnerie@is.it-management.at> wrote:
>> I did some benchmarking, now quite a while ago, which showed XFS to
>> be, for a totally write-bound workload, a *few* percent better than
>> ext3/JFS, but note that this is only a minor difference.
XFS is a very active project and, in my opinion, the best filesystem
for UNIX. Apart from a nasty bug back in the second half of 2007 (if I
remember correctly), it's very reliable and fast. I've got more than a
dozen production servers running it since 2002 (aproximattely) and
I've never ever had a problem with it (no data loss, always an
outstanding performance, etc). I also have eight PostgreSQL servers
(8.1 and 8.3 versions) on XFS. As with everything, if you know how to
finetune it (and I would not call myself an expert on it), then you
get a performance boost.
Regarding the benefits of XFS on PostgreSQL, I've come to the
conclusion that, the bigger the database and tables, the better. With
small databases with small tables, the difference in performance...
well, you won't notice it. But try a 30 GB... ;-)
Still, all these "convictions" are very hard to prove. Hard as in
"very much time consuming". I've not run benchmarks in about 4 years,
to be honest, so I would understand you not taking my experience as
"reliable source of information" :-P
--
Jaume Sabater
http://linuxsilo.net/
"Ubi sapientas ibi libertas"
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-admin@postgresql.org
Cc: jsabater@gmail.com
Subject: Re: postgresql and xfs filesystrem
In-Reply-To: <3786f7bb0901252334oe0f1f90n3e1ea0a539949733@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