I'm curious if anyone out there has done any experimentation or comparisons between file systems and database performance. On Linux, I'm wondering what is the optimal file system for a postgres database. Also, what settings (inode, etc) are ideal for it? Is this something that may drastically differ based on the data in the database?
If you are looking for a question relating to general filesystem / database performance, this post has some good information.
However, I would like to get as much advice on insert performance opposed to read performance as possible. Thanks for all of the great answers!