From: Michael Monnerie <michael.monnerie@is.it-management.at>
To: pgsql-admin@postgresql.org
Subject: Re: postgresql and xfs filesystrem
Date: Mon, 26 Jan 2009 01:14:30 +0100
Message-ID: <200901260114.38476@zmi.at> (raw)
In-Reply-To: <d6d6637f0901251106s2e79467m1fe66b692a383508@mail.gmail.com>
References: <eb90f15e0901251047k6b8bacfm9fdf0d9e4aa9155a@mail.gmail.com>
<d6d6637f0901251106s2e79467m1fe66b692a383508@mail.gmail.com>
On Sonntag 25 Januar 2009 Christopher Browne 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.
Remember that the structure of XFS consists of independent allocation
groups. If your database is big enough to cross several AGs, it might
increase performance by using several CPUs parallel, as an AG is
independent of the others.
> The fact that XFS isn't one of the "more highly supported"
> filesystems on Linux is something I'd consider a *way* more important
> factor.
It looks like a very active project, see:
http://xfs.org/index.php/XFS_Status_Updateshttp://oss.sgi.com/projects/xfs/training/index.html
I read a lot about XFS during the last weeks, and tested it. So far, it
was good, and we use it on a test server now with good performance and
reliability (several power outages and kernel crashes happened, no data
loss or anything).
But anyway, I guess the most performance can be gained by optimizing
your postgresql.conf, and increasing memory and using a better RAID with
faster and more 15k SAS disks. The filesystem is not that important for
postgres.
mfg zmi
--
// Michael Monnerie, Ing.BSc ----- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4
Attachments:
signature.asc (application/pgp-signature, 196B) download
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: michael.monnerie@is.it-management.at
Subject: Re: postgresql and xfs filesystrem
In-Reply-To: <200901260114.38476@zmi.at>
* 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