From: Ezra Taylor <ezra.taylor@gmail.com>
To: Jaume Sabater <jsabater@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: postgresql and xfs filesystrem
Date: Mon, 26 Jan 2009 11:01:20 -0500
Message-ID: <eb90f15e0901260801v6c5e1044j4c72da2f0de423a1@mail.gmail.com> (raw)
In-Reply-To: <3786f7bb0901252334oe0f1f90n3e1ea0a539949733@mail.gmail.com>
References: <eb90f15e0901251047k6b8bacfm9fdf0d9e4aa9155a@mail.gmail.com>
<d6d6637f0901251106s2e79467m1fe66b692a383508@mail.gmail.com>
<200901260114.38476@zmi.at>
<3786f7bb0901252334oe0f1f90n3e1ea0a539949733@mail.gmail.com>
Jaume:
What about XFS performance on databases larger than 1 TB. We
are successful running postgres on zfs with x4500 but I'm interested using
commodity hardware.
On Mon, Jan 26, 2009 at 2:34 AM, Jaume Sabater <jsabater@gmail.com> wrote:
> 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"
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
Ezra Taylor
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: ezra.taylor@gmail.com, jsabater@gmail.com
Subject: Re: postgresql and xfs filesystrem
In-Reply-To: <eb90f15e0901260801v6c5e1044j4c72da2f0de423a1@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