Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1naLS8-0000jc-Qw
	for pgsql-admin@arkaria.postgresql.org; Fri, 01 Apr 2022 17:52:52 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1naLS7-0002Lp-IH
	for pgsql-admin@arkaria.postgresql.org; Fri, 01 Apr 2022 17:52:51 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <rui@crazybean.net>)
	id 1naLS7-0002Lg-7n
	for pgsql-admin@lists.postgresql.org; Fri, 01 Apr 2022 17:52:51 +0000
Received: from impout003aa.msg.chrl.nc.charter.net ([47.43.20.27]
 helo=impout003.msg.chrl.nc.charter.net)
	by makus.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <rui@crazybean.net>)
	id 1naLS4-0000yc-Hg
	for pgsql-admin@lists.postgresql.org; Fri, 01 Apr 2022 17:52:50 +0000
Received: from cerberus.crazybean.net ([71.11.29.254])
	by cmsmtp with ESMTP
	id aLP8noWJvcPzXaLP9nKiLi; Fri, 01 Apr 2022 17:49:47 +0000
Authentication-Results: crazybean.net; none
X-Authority-Analysis: v=2.4 cv=Wa8f1mtX c=1 sm=1 tr=0 ts=62473b3b
 a=GkUsAQdcAzAk0MT19QAIRQ==:117 a=GkUsAQdcAzAk0MT19QAIRQ==:17
 a=xqWC_Br6kY4A:10 a=z0gMJWrwH1QA:10 a=pGLkceISAAAA:8 a=A5VpxUUnAAAA:8
 a=Q6Ojrw04AAAA:8 a=8VpDeP3kAAAA:8 a=JZPMHZITAAAA:8 a=074uQarDYQtGLImE9uQA:9
 a=QEXdDO2ut3YA:10 a=C_gwVL7RR9cA:10 a=uar3UI-X7uIA:10 a=-E0vlWde17EA:10
 a=-FEs8UIgK8oA:10 a=NWVoK91CQyQA:10 a=OLyf_lBqs-KWrzw_7zoA:9
 a=Fmzzhh6UgmjHaQG8:21 a=_W_S_7VecoQA:10 a=8j-cVVd6oLxmx3B0XEla:22
 a=x58pXJj3Pl9T3GLWE5Uy:22 a=4usT_ig5Z9dc9rfDnR7G:22
Received: from smtpclient.apple (<unknown>
 [2001:470:e117:3:5dd9:3f8d:400:4e24])
	by cerberus.crazybean.net (OpenSMTPD) with ESMTPSA id b5ea0ea8
 (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256:NO);
	Fri, 1 Apr 2022 13:49:46 -0400 (EDT)
From: Rui DeSousa <rui@crazybean.net>
Message-Id: <41B83C10-CE63-467C-A613-FD457237A31B@crazybean.net>
Content-Type: multipart/alternative;
	boundary="Apple-Mail=_423465D5-297F-46D0-8727-DE690AEF5353"
Mime-Version: 1.0 (Mac OS X Mail 15.0 \(3693.40.0.1.81\))
Subject: Re: WAL & ZFS
Date: Fri, 1 Apr 2022 13:49:46 -0400
In-Reply-To: <4fe1d719-4f08-7b10-90c3-43514453757d@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
To: Mladen Gogala <gogala.mladen@gmail.com>
References: <FC215502-166A-49DB-B3DA-D08727A34C0B@elevated-dev.com>
 <4fe1d719-4f08-7b10-90c3-43514453757d@gmail.com>
X-Mailer: Apple Mail (2.3693.40.0.1.81)
X-CMAE-Envelope: 
 MS4xfMtJLPPxdSWSEoA2Szgu5lKrNsCtvYO2LfQD9gTckjhD8teKK1auIl/njnX05eCGc2rZ8sA5KJwoUngMYnlX/pPGwAJh3YS5VJ+x8pZ4heDchp8Wdt7u
 jkXWIfzBHNG6KhdhplPzNBSXFtsWJu5rM0M09Hf42ZW1xq966U3rwYLnGehMlmy4kembBSD9qlZu5O1JXk5cM8lG8dLkxwM4JnhwVTZw62Jbayml3pgivaWq
 GZmXERNIKDP9MPKWTnMYoQ==
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/41B83C10-CE63-467C-A613-FD457237A31B%40crazybean.net>
Precedence: bulk


--Apple-Mail=_423465D5-297F-46D0-8727-DE690AEF5353
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8



> On Mar 31, 2022, at 7:26 PM, Mladen Gogala <gogala.mladen@gmail.com> =
wrote:
>=20
> Here are several articles that caution against ZFS:
> =
https://forums.servethehome.com/index.php?threads/very-slow-zfs-raidz2-per=
formance-on-truenas-12.33094/ =
<https://forums.servethehome.com/index.php?threads/very-slow-zfs-raidz2-pe=
rformance-on-truenas-12.33094/>
> =
https://serverfault.com/questions/791154/zfs-good-read-but-poor-write-spee=
ds =
<https://serverfault.com/questions/791154/zfs-good-read-but-poor-write-spe=
eds>
> =
https://www.phoronix.com/scan.php?page=3Darticle&item=3Dubuntu1910-ext4-zf=
s&num=3D3 =
<https://www.phoronix.com/scan.php?page=3Darticle&item=3Dubuntu1910-ext4-z=
fs&num=3D3>
> 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.
>=20
>=20

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 =E2=80=94 =
well there you go.  I would not recommend using anything other than =
RAID10 i.e. stripe of mirrors. =20

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



--Apple-Mail=_423465D5-297F-46D0-8727-DE690AEF5353
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html><head><meta http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3Dutf-8"></head><body style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; line-break: after-white-space;" class=3D""><br =
class=3D""><div><br class=3D""><blockquote type=3D"cite" class=3D""><div =
class=3D"">On Mar 31, 2022, at 7:26 PM, Mladen Gogala &lt;<a =
href=3D"mailto:gogala.mladen@gmail.com" =
class=3D"">gogala.mladen@gmail.com</a>&gt; wrote:</div><br =
class=3D"Apple-interchange-newline"><div class=3D"">
 =20
    <meta http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3DUTF-8" class=3D"">
 =20
  <div class=3D"">
    <div class=3D"moz-cite-prefix">Here are several articles that =
caution against ZFS:</div><p class=3D""><a class=3D"moz-txt-link-freetext"=
 =
href=3D"https://forums.servethehome.com/index.php?threads/very-slow-zfs-ra=
idz2-performance-on-truenas-12.33094/">https://forums.servethehome.com/ind=
ex.php?threads/very-slow-zfs-raidz2-performance-on-truenas-12.33094/</a></=
p><p class=3D""><a class=3D"moz-txt-link-freetext" =
href=3D"https://serverfault.com/questions/791154/zfs-good-read-but-poor-wr=
ite-speeds">https://serverfault.com/questions/791154/zfs-good-read-but-poo=
r-write-speeds</a></p><p class=3D""><a class=3D"moz-txt-link-freetext" =
href=3D"https://www.phoronix.com/scan.php?page=3Darticle&amp;item=3Dubuntu=
1910-ext4-zfs&amp;num=3D3">https://www.phoronix.com/scan.php?page=3Darticl=
e&amp;item=3Dubuntu1910-ext4-zfs&amp;num=3D3</a></p><p class=3D"">And =
finally, this:
      <a class=3D"moz-txt-link-freetext" =
href=3D"https://storytime.ivysaur.me/posts/why-not-zfs/">https://storytime=
.ivysaur.me/posts/why-not-zfs/</a></p><p class=3D"">I would consider =
Linux ZFS only for toy databases that do not
      hold any serious data.</p><div class=3D""><br class=3D""></div>
    </div></div></blockquote><br class=3D""></div><div>I call bullshit. =
I have used ZFS with better performance and it offers higher degree of =
management of the system.</div><div><br class=3D""></div><div>I look at =
one articles you pointed out and it was using RAIDZ2 =E2=80=94 well =
there you go. &nbsp;I would not recommend using anything other than =
RAID10 i.e. stripe of mirrors. &nbsp;</div><div><br =
class=3D""></div><div>If you=E2=80=99re using RAIDZ# then performance is =
going to be heavily impacted and I would <b class=3D"">highly</b> <b =
class=3D"">recommend</b> <b class=3D"">NOT using RAIDZ# for a database =
server.</b></div><div><br class=3D""></div><br class=3D""></body></html>=

--Apple-Mail=_423465D5-297F-46D0-8727-DE690AEF5353--