pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Best filesystem
4+ messages / 4 participants
[nested] [flat]

* Best filesystem
@ 2006-02-15 10:42 Arnau Rebassa Villalonga <arebassa@androme.es>
  2006-02-20 15:41 ` Re: Best filesystem Chris Browne <cbbrowne@acm.org>
  0 siblings, 1 reply; 4+ messages in thread

From: Arnau Rebassa Villalonga @ 2006-02-15 10:42 UTC (permalink / raw)
  To: pgsql-admin

Hi all,

   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.

Cheers!
-- 
Arnau




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Best filesystem
  2006-02-15 10:42 Best filesystem Arnau Rebassa Villalonga <arebassa@androme.es>
@ 2006-02-20 15:41 ` Chris Browne <cbbrowne@acm.org>
  0 siblings, 0 replies; 4+ messages in thread

From: Chris Browne @ 2006-02-20 15:41 UTC (permalink / raw)
  To: pgsql-admin

arebassa@androme.es (Arnau Rebassa Villalonga) writes:
>    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.

As far as I can tell, ext3 is the best *supported* filesystem for
Linux, and support trumps performance 99 days out of 100.

The trouble with all the other filesystems is that vendors are likely
to throw up their hands and ignore you if you report problems with
them, and "not getting your database eaten by a filesystem error" is
*WAY* more important than eking out some fraction of a percent
improvement in write performance.
-- 
output = ("cbbrowne" "@" "cbbrowne.com")
http://cbbrowne.com/info/linuxxian.html
"Heavy music didn't start in  Seattle.  It started in Katy, Texas with
King's X" -- Jeff Ament/Pearl Jam



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Best filesystem
@ 2006-02-15 10:48 Arnau <arnaulist@andromeiberica.com>
  2006-02-15 12:55 ` Re: Best filesystem Christopher Browne <cbbrowne@acm.org>
  0 siblings, 1 reply; 4+ messages in thread

From: Arnau @ 2006-02-15 10:48 UTC (permalink / raw)
  To: pgsql-admin

Hi all,

   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.

Cheers!
-- 
Arnau



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Best filesystem
  2006-02-15 10:48 Best filesystem Arnau <arnaulist@andromeiberica.com>
@ 2006-02-15 12:55 ` Christopher Browne <cbbrowne@acm.org>
  0 siblings, 0 replies; 4+ messages in thread

From: Christopher Browne @ 2006-02-15 12:55 UTC (permalink / raw)
  To: pgsql-admin

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/;



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2006-02-20 15:41 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-02-15 10:42 Best filesystem Arnau Rebassa Villalonga <arebassa@androme.es>
2006-02-20 15:41 ` Chris Browne <cbbrowne@acm.org>
2006-02-15 10:48 Best filesystem Arnau <arnaulist@andromeiberica.com>
2006-02-15 12:55 ` Christopher Browne <cbbrowne@acm.org>

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