Re: ZFS filesystem - supported ? - Mailing list pgsql-general

> Phoronix has some very useful benchmarks:

> 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

( 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!

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com