By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,685 Members | 1,243 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,685 IT Pros & Developers. It's quick & easy.

Which file system do i have to choose?

P: n/a
Hi list,

i got an postgresql installation on linux (debian) with the htree
partitions:
1- system
2- postgresql data files
3- postgresql WAL logs(pg_xferlog)

Our standard file system is ext3. Now i heard, xfs is better for the
data files.
Is that correct, and if, why?
Or which file system is better for the postgresql installation? Do you
have preferences?

best regards,
Markus

--
Markus Rebbert <ma************@freenet.de>
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Thursday 18 December 2003 17:40, Markus Rebbert wrote:
Hi list,

i got an postgresql installation on linux (debian) with the htree
partitions:
1- system
2- postgresql data files
3- postgresql WAL logs(pg_xferlog)
First of all, YMMV. reiserfs/XFS/JFS are all good and fast. Ext3 might lag
behind them in certain configurations. Besides on some RAID configs and
controllers, JFS performs better. So you really need to test.
Our standard file system is ext3. Now i heard, xfs is better for the
data files.
Is that correct, and if, why?
XFS handles large files much better. Reiserfs handles small files much
better(With V4, it is roumoured to be good all along but linux 2.6 is not yet
widespread..)

With Ext3, you need to configure correctly what you journal and how. I don't
know much about ext3 but some configs are rather slower than others. So tune
it correctly.
Or which file system is better for the postgresql installation? Do you
have preferences?


That is almost a flamebait. Best thing you can do is benchmark yourself and
determine. For help you can search archives of performance list.

Shridhar
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.