pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Rui DeSousa <rui@crazybean.net>
To: Mladen Gogala <gogala.mladen@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: WAL & ZFS
Date: Fri, 1 Apr 2022 13:49:46 -0400
Message-ID: <41B83C10-CE63-467C-A613-FD457237A31B@crazybean.net> (raw)
In-Reply-To: <4fe1d719-4f08-7b10-90c3-43514453757d@gmail.com>
References: <FC215502-166A-49DB-B3DA-D08727A34C0B@elevated-dev.com>
	<4fe1d719-4f08-7b10-90c3-43514453757d@gmail.com>



> 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.330... <https://forums.servethehome.com/index.php?threads/very-slow-zfs-raidz2-performance-on-truenas-12.330...;
> https://serverfault.com/questions/791154/zfs-good-read-but-poor-write-speeds <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 <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/ <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.

view thread (13+ messages)  latest in thread

Message-ID: <41B83C10-CE63-467C-A613-FD457237A31B@crazybean.net>
Permalink:  ../41B83C10-CE63-467C-A613-FD457237A31B@crazybean.net/
Also on:    postgresql.org/message-id/41B83C10-CE63-467C-A613-FD457237A31B@crazybean.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: rui@crazybean.net, gogala.mladen@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: WAL & ZFS
  In-Reply-To: <41B83C10-CE63-467C-A613-FD457237A31B@crazybean.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox