Re: ZFS filesystem - supported ?

Mladen Gogala <gogala.mladen@xxxxxxxxx> · Tue, 26 Oct 2021 20:55:45 -0400



    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

        > 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