Kaarel wrote:


I feel incompetent when it comes to file systems. Yet everybody would like to have the best file system if given the choice...so do I :) Here I am looking at those tables seeing JFS having more green cells than others. The more green the better right? So based on these tests JFS ought to be the one?

Yes and no. Yes for the results. No for the tests that weren't run.

Database load is quite different. Its mixture of read and write load with a dynamics varying from one extreme to other, between these two.

All it says that if you want to choose a good file system for postgresql, look at JFS first..:-)

Besides all the tests were done on files file bigger than 1GB. If single file size is restricted to 1GB, it might produce a different result set. And postgresql does not exceed 1GB limit per file.

So still, quite a few unknowns there..

Best thing could be repeat those benchmarks on $PGDATA with your live data inside it. It could mimmic the load pretty well..


---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Reply via email to