Re: WAL & ZFS

[Rui DeSousa <rui@xxxxxxxxxxxxx>]

On Mar 31, 2022, at 7:26 PM, Mladen Gogala <gogala.mladen@xxxxxxxxx> wrote:

Here are several articles that caution against ZFS:

https://forums.servethehome.com/index.php?threads/very-slow-zfs-raidz2-performance-on-truenas-12.33094/

https://serverfault.com/questions/791154/zfs-good-read-but-poor-write-speeds

https://www.phoronix.com/scan.php?page=article&item=ubuntu1910-ext4-zfs&num=3

And finally, this: https://storytime.ivysaur.me/posts/why-not-zfs/

I would consider Linux ZFS only for toy databases that do not hold any serious data.

I call bullshit. I have used ZFS with better performance and it offers higher degree of management of the system.

I look at one articles you pointed out and it was using RAIDZ2 — well there you go.  I would not recommend using anything other than RAID10 i.e. stripe of mirrors.  

If you’re using RAIDZ# then performance is going to be heavily impacted and I would highly recommend NOT using RAIDZ# for a database server.