pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-admin@postgresql.org
Subject: Re: Best filesystem
Date: Wed, 15 Feb 2006 07:55:19 -0500
Message-ID: <87wtfwixxk.fsf@wolfe.cbbrowne.com> (raw)
References: <43F30708.9080001@andromeiberica.com>

Martha Stewart called it a Good Thing when arnaulist@andromeiberica.com (Arnau) wrote:
>    Which is the best filesystem in linux for postgresql? nowadays I'm
> using ext3, I don't know if other filesystems like XFS, reiser... would
> be better from the performance point of view.

Do you care more about performance?  Or reliability?

I think I'd rather see things 3% slower than they could perhaps be if
that diminishes the risk of suddenly losing a filesystem...

The last time I did a benchmark, I found JFS *slightly* faster than
XFS, and XFS slightly faster than ext3.  But then lost several JFS
filesystems to weird interactions between JFS and disk controller.

That was about 2 years ago; there have been new releases of both
filesystems, SCSI device drivers, as well as major kernel revisions.
It's not evident how much things have really changed.

At any rate, I would NOT put filesystem performance at the top of the
list; ability of vendors to provide support is something I would put
much higher.  That factor alone usually rules out both JFS and XFS...
-- 
select 'cbbrowne' || '@' || 'gmail.com';
http://linuxfinances.info/info/lsf.html
Rules of the  Evil Overlord #43. "I will maintain  a healthy amount of
skepticism when  I capture the beautiful  rebel and she  claims she is
attracted  to my  power  and good  looks  and will  gladly betray  her
companions if I just let her in on my plans."
<http://www.eviloverlord.com/;



view thread (4+ messages)  latest in thread

Message-ID: <87wtfwixxk.fsf@wolfe.cbbrowne.com>
Permalink:  ../87wtfwixxk.fsf@wolfe.cbbrowne.com/
Also on:    postgresql.org/message-id/87wtfwixxk.fsf@wolfe.cbbrowne.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: cbbrowne@acm.org
  Subject: Re: Best filesystem
  In-Reply-To: <87wtfwixxk.fsf@wolfe.cbbrowne.com>
  References: <43F30708.9080001@andromeiberica.com> <87wtfwixxk.fsf@wolfe.cbbrowne.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