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

From Mladen Gogala
Subject Re: ZFS filesystem - supported ?
Date
Msg-id a405a5fd-5c8e-32a8-a9c0-7d6d365606f9@gmail.com
Whole thread Raw
In response to Re: ZFS filesystem - supported ?  (Laura Smith <n5d9xq3ti233xiyif2vp@protonmail.ch>)
Responses Re: ZFS filesystem - supported ?
Re: ZFS filesystem - supported ?
List pgsql-general
On 10/26/21 05:35, Laura Smith wrote:
> Curious, when it comes to "traditional" filesystems, why ext4 and not xfs ? AFAIK the legacy issues associated with
xfsare long gone ?
 

XFS is not being very actively developed any more. Ext4 is being 
actively developed and it has some features to help with SSD space 
allocation. 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. That benchmark is brand new, done on the kernel 5.14. Of 
course, the only guarantee is doing your own benchmark, with your own 
application.

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




pgsql-general by date:

Previous
From: Michael Lewis
Date:
Subject: Re: How to copy rows into same table efficiently
Next
From: Michael Lewis
Date:
Subject: Re: Need recommendation on PARALLEL INDEX SCAN and PARALLEL APPEND