Home > mailing lists

Re: WAL & ZFS - Mailing list pgsql-admin

From	Rui DeSousa
Subject	Re: WAL & ZFS
Date	April 1, 2022 20:49:46
Msg-id	41B83C10-CE63-467C-A613-FD457237A31B@crazybean.net Whole thread Raw
In response to	Re: WAL & ZFS (Mladen Gogala <gogala.mladen@gmail.com>)
Responses	Re: WAL & ZFS (Scott Ribe <scott_ribe@elevated-dev.com>)
List	pgsql-admin

Tree view

On Mar 31, 2022, at 7:26 PM, Mladen Gogala <gogala.mladen@gmail.com> 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.

pgsql-admin by date:

From: Rui DeSousa
Date: 01 April 2022, 20:39:52
Subject: Re: WAL & ZFS

From: Scott Ribe
Date: 01 April 2022, 20:56:58
Subject: Re: WAL & ZFS

Re: WAL & ZFS - Mailing list pgsql-admin

Previous

Next