From: | Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com> |
---|---|
To: | Imre Samu <pella(dot)samu(at)gmail(dot)com> |
Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: ZFS filesystem - supported ? |
Date: | 2021-10-27 00:55:45 |
Message-ID: | 4d4fae2c-2e22-c9bc-ba86-263d63ae6aa9@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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!
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
From | Date | Subject | |
---|---|---|---|
Next Message | Benedict Holland | 2021-10-27 01:26:38 | Re: ZFS filesystem - supported ? |
Previous Message | Imre Samu | 2021-10-27 00:50:44 | Re: ZFS filesystem - supported ? |