Postgresql is another widely adopted open souce database system. It has an historical focus on correctness and scalability over pure speed. How todays heroes will perform with it?
First, lets examine the time needed to create a test database and populate it with 100K rows:
Again btrfs is very slow. On the other hand, EXT4 is the leader.
In this simple read-only test all filesystems perform quite well, but ext3 is noticeably slower. Will the complex, read-write test change anything?
Yes! EXT4 now is the leader now, with EXT3 in the second place. XFS badly performs, but it remain faster then BTRFS.
It's time to compare Sysbench results with pgbench ones. First, lets see how much time is needed to create a test database with scale factor set to 100:
XFS is the slower now, while EXT4 continue to be the faster.
It is time of real pgbench performance results now:
Again we see that ext4 is, by far, the true leader, but this time BTRFS secure a unexpected second place, right before ext3. XFS is the slower here.
So, what filesystem is the best for a postgresql workload? From the above results, it appear that you simply can not go wrong with EXT4.