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

help / color / mirror / Atom feed
From: Mladen Gogala <gogala.mladen@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: WAL & ZFS
Date: Thu, 31 Mar 2022 19:26:35 -0400
Message-ID: <4fe1d719-4f08-7b10-90c3-43514453757d@gmail.com> (raw)
In-Reply-To: <FC215502-166A-49DB-B3DA-D08727A34C0B@elevated-dev.com>
References: <FC215502-166A-49DB-B3DA-D08727A34C0B@elevated-dev.com>

On 3/30/22 17:32, Scott Ribe wrote:
> I've read all the info I could find re running PG on ZFS: turn off full page writes, turn on lz4, tweak recordsize so as to take advantage of compression, etc. One thing I haven't seen is whether a separate volume for WAL would benefit from a larger recordsize. Or any other tweaks???
>
> --
> Scott Ribe
> scott_ribe@elevated-dev.com
> https://www.linkedin.com/in/scottribe/
>
>
>
>
>
Phoronix has tested ZFS against Ext3, Ext4 and XFS. ZFS was consistently 
performing worse than all other file systems. Here is the test with Oracle:

https://blog.docbert.org/oracle-on-zfs/

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://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.


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

view thread (13+ messages)  latest in thread

Message-ID: <4fe1d719-4f08-7b10-90c3-43514453757d@gmail.com>
Permalink:  ../4fe1d719-4f08-7b10-90c3-43514453757d@gmail.com/
Also on:    postgresql.org/message-id/4fe1d719-4f08-7b10-90c3-43514453757d@gmail.com

 · 

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: gogala.mladen@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: WAL & ZFS
  In-Reply-To: <4fe1d719-4f08-7b10-90c3-43514453757d@gmail.com>

* 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