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 ) id 1naLWE-0000yg-OY for pgsql-admin@arkaria.postgresql.org; Fri, 01 Apr 2022 17:57:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1naLWD-0000rA-KM for pgsql-admin@arkaria.postgresql.org; Fri, 01 Apr 2022 17:57:05 +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 ) id 1naLWD-0000qy-9r for pgsql-admin@lists.postgresql.org; Fri, 01 Apr 2022 17:57:05 +0000 Received: from mailout.easymail.ca ([64.68.200.34]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1naLWA-000105-5T for pgsql-admin@lists.postgresql.org; Fri, 01 Apr 2022 17:57:04 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout.easymail.ca (Postfix) with ESMTP id BC4C87605F; Fri, 1 Apr 2022 17:56:59 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at emo05-pco.easydns.vpn Received: from mailout.easymail.ca ([127.0.0.1]) by localhost (emo05-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id yTajWa7LbKl4; Fri, 1 Apr 2022 17:56:59 +0000 (UTC) Received: from smtpclient.apple (unknown [4.28.96.150]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mailout.easymail.ca (Postfix) with ESMTPSA id 611767605E; Fri, 1 Apr 2022 17:56:59 +0000 (UTC) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 15.0 \(3693.60.0.1.1\)) Subject: Re: WAL & ZFS From: Scott Ribe In-Reply-To: <41B83C10-CE63-467C-A613-FD457237A31B@crazybean.net> Date: Fri, 1 Apr 2022 11:56:58 -0600 Cc: pgsql-admin Content-Transfer-Encoding: quoted-printable Message-Id: <698D568E-058B-430D-8339-ABDA350FA742@elevated-dev.com> References: <4fe1d719-4f08-7b10-90c3-43514453757d@gmail.com> <41B83C10-CE63-467C-A613-FD457237A31B@crazybean.net> To: Rui DeSousa X-Mailer: Apple Mail (2.3693.60.0.1.1) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Apr 1, 2022, at 11:49 AM, Rui DeSousa wrote: >=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. Actually, I found even the performance of RAIDZ1 to be acceptable after = appropriate configuration--current versions, lz4, etc.=