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 1qByJN-0005zI-R8 for pgsql-admin@arkaria.postgresql.org; Wed, 21 Jun 2023 13:55:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qByJM-0000rR-2Q for pgsql-admin@arkaria.postgresql.org; Wed, 21 Jun 2023 13:55:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qByJL-0000rI-Gw for pgsql-admin@lists.postgresql.org; Wed, 21 Jun 2023 13:55:51 +0000 Received: from mailout.easymail.ca ([64.68.200.34]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qByJI-003pZs-Kx for pgsql-admin@lists.postgresql.org; Wed, 21 Jun 2023 13:55:50 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout.easymail.ca (Postfix) with ESMTP id 52CFF615B2; Wed, 21 Jun 2023 13:55:45 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1687355745; bh=9rYVkzx15+ZekrhpFuZQD8IrDs1rPe3WMoA4JvqGMOQ=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From; b=uShe1W7cXrYduWoa5eGLHfis404xvrpxjE9AIwOVDxqfpTOIXngicxDzg09kmXIyU tNWQJBa5fOe+oUofg4qBKwTNFEIw0Ov+UO9l8O437K+HJpKsxht9159C8dVvpN2ZG9 +9932pmLJ+ZHWHvEv3oL1tk2810Xg+41t3FgZFcwW/ymDPhVzA319fn+1Mqcua6Nag SG/DhRfDVGxh7s6fcMbRUUVY1kHVarm406u7T1lGjk8wWH7suZ9LgJMAA3i37Re5LY bW+Y1tCJB0fDV1Dv6Bkf3YnteEmA7n3nT9XNhaoomcgViepj1YpOvSPPcwgON07XkJ pjh4Mu9fViPzA== X-Virus-Scanned: Debian amavisd-new at emo09-pco.easydns.vpn Received: from mailout.easymail.ca ([127.0.0.1]) by localhost (emo09-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 7fHh_FjIzb9t; Wed, 21 Jun 2023 13:55:44 +0000 (UTC) Received: from smtpclient.apple (unknown [165.140.184.195]) (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 A23A3614B8; Wed, 21 Jun 2023 13:55:44 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1687355744; bh=9rYVkzx15+ZekrhpFuZQD8IrDs1rPe3WMoA4JvqGMOQ=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From; b=lqMlZ3kovHt2/A2tN2nhPuhrfLqjjSXuu+7ufv9xBxHMjQcZK7W75D4ZT8Zh+9Cp3 wA+iX+IZ47z/8MQfnnIje0R8gpazdKLbNGIoqojXc3KDxc5tvxD8Sg2dNoh6F/ZiVS mjk2L4UBiO2x5eTXP+rG4aK9DOW64FpGtgJ2So1GcyVHB8e5lQilVsH87SROtxYKOs wYKMRL70JsmNz73F/0X+H75XOeuHu2NFqEQ/XiA+Gv+pHvK0q8RTecshYMp2zDHRI9 axqYdKwkJJ6acqAW1EgWA2OdT6eAG8tk4FgkqUeKYIA/AjqU/LExc9Y+A2dBIRJ5Fz HBHoLcRJhxZzw== Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3731.600.7\)) Subject: Re: Question about wal_compression and what to expect From: Scott Ribe In-Reply-To: Date: Wed, 21 Jun 2023 07:55:33 -0600 Cc: "pgsql-admin@lists.postgresql.org" , "Wetmore, Matthew (CTR)" Content-Transfer-Encoding: quoted-printable Message-Id: References: To: Sean O'Grady X-Mailer: Apple Mail (2.3731.600.7) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Jun 21, 2023, at 7:51 AM, Sean O'Grady wrote: >=20 > Yes, my question was essentially do I need to separately compress WAL = files for storage/archiving even with wal_compression set. So, I think = you've answered my question. If WAL files use per-page compression internally, you won't get much = benefit from compressing them. If they use lz4 internally, then sure, = bzip'ing them will get a little benefit, but nowhere near the normal = amount.=