Evaluating Filesystem Performance for PostgreSQL



Examining results from basic simple I/O tests run against Linux filesystems.


The Linux operating system provides a number of file systems that can be used, as well as volume management and hardware or software RAID. We are running performance tests for database tuning, and are curious if the file systems really behave like we expect them to, especially when used in conjunction with RAID or volume management. Are these file systems being used in manners for which they were designed? There is also more to file systems than how fast we can read to them or how fast we can write to them. How reliable is the file system, and how do be prove it? We have collected lots of data and want to share it.

This talk will focus on Hardware RAID and select Linux filesystems.

Speaking experience