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.
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] |