Hi List As im also interesting in the same question I asked what FS I should use for postgres.
after lots of answers the thread got quite big :) and still growing. http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=00c501c3970b%246900f250%240500a8c0%40canaan.co.il&rnum=1&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DISO-8859-1%26q%3DRecomended%2BFS%26meta%3Dgroup%253Dcomp.databases.postgresql.general What I understood from it is that JFS is more suitable and any way I should not use Reiseref as its not good in handling big files. Also The HD should be SCSI and even better RAID ( Never IDE - to avoid file corruptions ). Also check the following links Generic FS benchmarks: http://fsbench.netnation.com/ Hardware consideration for Postgres ( probably good thinking for other db too ) http://www.ca.postgresql.org/docs/momjian/hw_performance/ Cheers -------------------------- Canaan Surfing Ltd. Internet Service Providers Ben-Nes Michael - Manager Tel: 972-4-6991122 Fax: 972-4-6990098 http://www.canaan.net.il -------------------------- ----- Original Message ----- From: "Maxim K." <[EMAIL PROTECTED]> To: "Linux-IL Mailing List" <[EMAIL PROTECTED]> Sent: Sunday, October 19, 2003 4:50 PM Subject: filesystem for database box > Hello, Linux People! > > after short consultation, i have come to this conclusion about which > filesystem i should use on my database box (or server) > the winner is: ex2 linux extended filesystem, yes, lassies & lads > > - "why not ext3/Reiser's ?" > - "because journalling is already implemented in the DBMS." > - "why not jfs then ? > - "it is too young, my friends + journalling..." > - "why not xfs , it is so ... juicy ? > - "it is too resource demanding (i have p2 670MHz + 256 MB )" > > if somebody thinks otherwise, please tell me why! > thank you. > ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
