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 1qByiE-0007Xf-Qd
	for pgsql-admin@arkaria.postgresql.org; Wed, 21 Jun 2023 14:21:34 +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 1qByiD-0004M9-M2
	for pgsql-admin@arkaria.postgresql.org; Wed, 21 Jun 2023 14:21:33 +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 <scott_ribe@elevated-dev.com>)
	id 1qByiD-0004GP-BL
	for pgsql-admin@lists.postgresql.org; Wed, 21 Jun 2023 14:21:33 +0000
Received: from mailout.easymail.ca ([64.68.200.34])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <scott_ribe@elevated-dev.com>)
	id 1qByiA-003RXy-Md
	for pgsql-admin@lists.postgresql.org; Wed, 21 Jun 2023 14:21:32 +0000
Received: from localhost (localhost [127.0.0.1])
	by mailout.easymail.ca (Postfix) with ESMTP id 0A769E12EF;
	Wed, 21 Jun 2023 14:21:29 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com;
	s=easymail; t=1687357289;
	bh=3OOcoEE5kgwZehG92prKBqr1MWchEGDEFhVVpKXw7ME=;
	h=Subject:From:In-Reply-To:Date:Cc:References:To:From;
	b=BLVpVXDu2CDdxp4gtCTUjcmpEh5ZSHw8L3LkIyGLXWLYqNRB/aI7AG03Jows0azOn
	 9Vt92oN4xGlX0eEoyZ4ROeJNFpn/ahuvyuSe0KS4dFSeaPK5OhZ4h4ok5YD5CIRHzu
	 itMsiAcFyv7Io4t991s9ctHQaZpXyO8P0uaoRwgQm6hqCQK2wrSUTty13wBQEHlPdt
	 qvSsvobBeDIT5/PJTMvExjgjF2+sTmaYTbEjgBRKYbjVxF3pI3HKHRYltbHacnHvAD
	 +SdBVqGMas+foK7SL4U6Qt4jN0XWZ/m+MaRw7DSSI5pNnyE4ueNqLMUWRRRPXr8vsl
	 C/2eGMjVWVpWA==
X-Virus-Scanned: Debian amavisd-new at emo08-pco.easydns.vpn
Received: from mailout.easymail.ca ([127.0.0.1])
	by localhost (emo08-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id mCFo3EBZC5wG; Wed, 21 Jun 2023 14:21:28 +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 60F49E0A69;
	Wed, 21 Jun 2023 14:21:28 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com;
	s=easymail; t=1687357288;
	bh=3OOcoEE5kgwZehG92prKBqr1MWchEGDEFhVVpKXw7ME=;
	h=Subject:From:In-Reply-To:Date:Cc:References:To:From;
	b=Jd36/WpJhBoYOYUCnnUnFmYSjIA0M1aKnxfQVnOwHqI0bXsTXD23B7HXh8cNbWpA9
	 366b5/tfDZeFP0zO3FJ/bky+LmOSRbcXdS+MVflm6YWzOEulj3ktbRTdluXfEMf2Lj
	 PKI6eTxaolNZVoWZppy60M0rWEyi9nI+niy5J/JC1Tgl97YrP4cFs6S6BX/Qc1Q1YW
	 TgYLbaPFXydYVvxpLkkuAHmMFSYIpZPeSEt25sHFulwtSHkNXtJNEdaQp4sW7Gortf
	 ZRDouWH1uz1O2UVU0Y7tCYFkFWNNDk1dZXKsbZpqG3ePxxFd3IisrU9zG5MzQ5a0jV
	 HABXWwZoopxKg==
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 <scott_ribe@elevated-dev.com>
In-Reply-To: <1c92a69086aa7046c2141a3849b1eff92eb68a37@hey.com>
Date: Wed, 21 Jun 2023 08:21:17 -0600
Cc: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>,
 "Wetmore, Matthew (CTR)" <matthew.wetmore@express-scripts.com>
Content-Transfer-Encoding: quoted-printable
Message-Id: <5FF92EA7-BA36-4005-958E-5ACBFD05A7AF@elevated-dev.com>
References: <1c92a69086aa7046c2141a3849b1eff92eb68a37@hey.com>
To: Sean O'Grady <sean@thingee.com>
X-Mailer: Apple Mail (2.3731.600.7)
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/5FF92EA7-BA36-4005-958E-5ACBFD05A7AF%40elevated-dev.com>
Precedence: bulk

> On Jun 21, 2023, at 8:04 AM, Sean O'Grady <sean@thingee.com> wrote:
>=20
> With archive_timeout set I think WAL files will often (at least in my =
case) be created before they are filled, and in those cases there should =
be a larger benefit, correct?

Good point--I believe you are correct about that.