Re: ZFS filesystem - supported ?

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: ZFS filesystem - supported ?
Date: 2021-10-27 04:08:03
Message-ID: ba5c2513-86c8-878b-aa4f-1b03ec26380e@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Guyren Howe 2021-10-27 04:33:03 Best options for tracking history of data?
Previous Message Ron 2021-10-27 04:02:21 Re: Need help understanding error message [RESOLVED]