On 10/26/21 7:55 PM, Mladen Gogala wrote:
On 10/26/21 20:50, Imre Samu wrote:
> Phoronix has some very useful benchmarks:
>
https://www.phoronix.com/scan.php?page=news_item&px=Linux-5.14-File-Systems
<https://www.phoronix.com/scan.php?page=news_item&px=Linux-5.14-File-Systems>
> Ext4 is much better than XFS with SQLite tests and almost equal with
> MariaDB test. PostgreSQL is a relational database (let's forget the
> object part for now) and the IO patterns will be similar to SQLite and
> MariaDB.
there is a link from the Phoronix page to the full OpenBenchmarking.org
result file
and multiple PostgreSQL 13 pgbench results included:
https://openbenchmarking.org/result/2108260-PTS-SSDS978300&sor&ppt=D&oss=postgres
<https://openbenchmarking.org/result/2108260-PTS-SSDS978300&sor&ppt=D&oss=postgres>
( XFS, F2FS, EXT4, BTRFS )
Regards,
Imre
Wow! That is really interesting. Here is the gist of it:
XFS is the clear winner. It also answers the question about BTRFS. Thanks
Imre!
XFS is 1.08% faster than ext4. That's very close to being statistical noise.
--
Angular momentum makes the world go 'round.
