pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedBest 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