PostgreSQL benchmarks:
Another popular, open source database server is PostgreSQL. Which filesystem is the fastest here?
The first test is about creating and populating a PostgreSQL database with 100 thousand rows, using sysbench oltp prepare test:
XFS is slightly slower then EXT4 in this case.
As before, we want to test PostgreSQL performances both with simple, read-only queries:
and complex (transactional, read-write) queries:
Again the high-end controller helps XFS to remain in short distance from EXT4, but the latter is ahead by a ~10% margin.
Will pgbench confirm these data? Let's see the prepare time first:
and execution scores then, expressed in transactions per second (TPS):
While the prepare time was very similar, EXT4 remains the strong leader in TPS benchmark with a score almost 100% greater than XFS one.
So, it seems that for PostgreSQL databases, EXT4 remains (by far) the better choice.
Please note that pgbench transactional benchmark was the only one to be affected by write barriers on vs write barriers off: in the former case, I recorded performances over two times lower than in the latter (with both EXT4 and XFS).