Postgres vs. File Systems: A Performance Comparison
scale
zfs/default
zfs/tuned
btrfs
ext4
xfs
100
61028
64057
33352
85291
85765
1000
32568
36066
27952
58736
58991
10000
3822
6068
6541
30495
30977
Table: read-write results
For the read-only tests, the results are (again) pretty even - ZFS is a bit slower than the other file systems, particularly for the larger scales, similarly to the smaller machine.
For read-write tests, the differences are much more dramatic. EXT4/XFS are the clear winner. ZFS keeps pace on the two smaller data sets (that fit ...
Read more at enterprisedb.com