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 1ltb7R-0001mw-UU for pgsql-admin@arkaria.postgresql.org; Wed, 16 Jun 2021 19:22:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ltb6v-0006WW-4y for pgsql-admin@arkaria.postgresql.org; Wed, 16 Jun 2021 19:22:01 +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 1ltb6u-0006Vb-D0 for pgsql-admin@lists.postgresql.org; Wed, 16 Jun 2021 19:22:00 +0000 Received: from sonic302-25.consmr.mail.ne1.yahoo.com ([66.163.186.151]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ltb6r-0002sQ-MO for pgsql-admin@postgresql.org; Wed, 16 Jun 2021 19:21:58 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=prodigy.net; s=s2048; t=1623871316; bh=Ozj36V/OxcrYcnW6mcn3aAMH4FEleV+JQ6qvEwjS01A=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=QCj2AybQwZCK17ipjrxxRMPI25CrJkdfL5Tn7KrIxYeHYpohXQ9c60AeHh0osCjzByQw55yBjJZjFUIEfaUW7XnAhlgWnQ/PILjLuziBsxbGikAqdVZEFOKqjclBzIj0GuO0UGBO2FO/nkT5Hg6iFBVWGb9TSjgs+kJBh8NIbmE0jg8o3+22tSEm9jXic/dCdlF7Sx7/ejvusrrtLlMS0un5LWIVQnL8zPdQPE//1J/xoujwqyz9hd34iskGz51/da8tkwphSw9ymFhGTNex2kLP3UcUoY0PgMtcvIBUxR4EVqZVyEhlSlrrY7y3mbJzxMo7yuSqfHwbHwPdnDD18w== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1623871316; bh=t2RqqtsXS2dg76HMwolQq6XgLC4Vp96k0PcluZg1OZf=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=Nk4VkiFj3rxc9d/NKqHjq6LDHJVxAYq3rqpYgOxng7SPRBZVW+TkK7ORVUVAPMQj8i64Nb0jpnGMnNmT75Q1BxGHw//yiZczhrh7eOH9t0Pa/QqehG3nuvctqqwbOq1pBVqJOJf1EYkailiWYST/6NIvHihFJfPhjsCKVpckPiGv9NM4Me4A02cLJYpNPbZm7L9R/ia00Kf06mvZvDnOs1wGpn/iawj1F1PguE8BoOJAEaj9qab2Snn1FX0IYY5sbxHxglON0zsp/M1b+5DZ/rcTC6eRqylqDWC5PWHuMErJa7v1Tv5e2uHoHsK105tptU9y71Xvjbc5zaHhokMo3w== X-YMail-OSG: uAZgHYIVM1lVFLhLFIVGiz7FcjwFY7BDAL_ir1.TkWuzj2kfwVDRj8d1hFRUlT2 I9V84.G0sVxAnlfdz6VcOVU2zCtftXeBbBcXfwd97lhx.ugSxPTuNmARAz4waQQh_D0lQooo6SrW Za1C_kwSmbDLlqK3R0voHJieg7oOglvpOcwDKEsRp2zxGQc1uCgbfRRnlqwH0GbqK4xzlVPSMBQY P8zZU1L2LI9mrhJBwE4L2KOHddWKejxEpZavxCRUIaK6b4B0j0wveNfrS0yGlS14KUsJTeA5X49y I5q0jq23h9MvTRmT3vE70yPKqvYL5FldAa3F3QCzy_NLIWN0fOWqlRaH0QkmCxPUgfdq_p9lPRNW 9HR21fqMaKtTrfwvsW1JLDkp4K_GTu5JI2kcCSOZhWbqPF_J4xD9vEHQQ_NlpVATOFdk680FhcC. lOUWl6qTWPxlVr7j8ly0BBunYAXfFQmuplxBVU2jjbp4jKhCsN51PbLjqOageGfWjmKwdJwFq0aL 6Eypqt_MWDLgmc41eYROsjqmYKSWlKkX5Vd0z8y_uJO_Vdlz6S82xGzq7en6StjVyQBvBLlnfx0b 7rn5Sqisl1BhjMmiAlQHSI5PUvHhMYrD3NcAW5PylIf9Jc5MkinnkuAZ_dKRWZfYc8mGnsLH9uIA d.JbJvJmAcRoYB3WmfCDfPKM9t6Cmxl6mIafxykxeJnr7b52aTct1A2eYxE8trFw6rjjVMhK3MT8 0R5i6uPjspiKn14Wvm2tEbtxjcs55BYifFesaHxd7WgsI5yE1VLw1aEziZm0XbCGMP07AX5J9Qwy RdOVe6NvxDA3WcCRH5XtZIheWMcOVr4ftqXFMh53hY5aLvK3fgsaE8cLLmy8V6vrX_7jeNKtEcLv BViJSEwMX6J0URW9TSsvJgbhA.LWovCMaviTw_y2S0zK4giVSBYxBX2C5nQiGqSwfwXFxp_vWxKW RIMY2oKituxMCOD0Nya4DX_SivxaP3mYBXEyfqnjfIkwNwvT8YCIx1z5dgs10AOXtxsUkFaswaR_ Y0ao2X6CrPVSBKWlVxzxPOoaI9LMzjLPO4sjh1NiMHPX.Gr67w.8AILz1psHjRraxiPIpal9Joqd HEv8w88vslwWY2sPYHowRVBXybrh2VYTZDq3AggfmA0DlZSeNfd9cqCV9osDSvS1GcPgmU859U2n zmDR_9ViGhJ0uf1EhpnBdD7CP2fHO0ysokkgrux2Dbkc8u6yFzSke913kVQgkTlB3q3VGYwBdWXB K4gAEuidWsuUiPI3M2YNNqQ_102k_KBxYACSDVSLp3XQsu2tzd_ZBhyJfpR3ia49D1u636mG9dpJ 00SgOHfTpXX3u52ULx.7RDUEBGCmAuRBd3zrNUFIQZi84XwtsPROW6E6wNlfNLr.PywG3Ta5acRW HDil7ZGPIJdiYwC4FVG1WeGBmAziZz2NLOicqYd.pf.s5zs24JOxCNxslIVec7KKFTNBp_laxdzX 8zugeRLEzEYwZPQUPPflwBN0HqfSBakoIQ23j5JZ0xEmh9IwryBJSsFPjnfO2KZvdU35_OgE2XUZ gt9w9fqKYxfQSebyNfzsXUULMfBW2XRqBp.aMnr_b.YuIH_e5DAfs0._FO3FXGvnCqO0hKKXnJ6y 3UzhjfXxup9XvQkXdBnq7iJwqkq_DJhrglVuhohNMAN5bHOTm33ZztYvfj9_zWAXK3_kBSrIQ.Da g.g0NC9Km2nqNkpyyvt063Qh.WWrI.EQFlTx_UWN.EOvArh1Qtm6AHUMkWhadvSpqtPQaX4FUw9T .GSz62nk6IjW40RmM1qGhVshsz_Qkejf3n7x18ldA.7Rm.jtA.PdSS3rn.6Su4f5vtC5XtKfQlZW _QK3lbH.HOMX7dOp.XdTE8Q6SeM0UZKi6pkC4Cyy99yCjOQiAp6LCMnURbPgwvq7h0ZGLHN7DOf3 ZbQphk8ddt_0XMpAEye7xPcvVYEbGdHFI6viqJTcvmGBp3gIsAszMf_82Q0FzvDnja6.HOE8Ykq8 rRYdxJvnN67E6Y9xawjVSGqsGjNxBAFGZazMdc9mhM_4JV4j21mGKyJi8PaVHwsgVJS5.vGWjEqA PHNko6yS3jopwCpMXv3_QuOvrd7z8GIfqh7LxGWuHcjyInvORPd.rppnykxQwDXqsIWwOHx.qTW1 r1jB7ZwoDuWd7gYIfpgmh6qzCnWomxQq3VOFuP6mXCVsC0mDsMvqo6vdtsTl9uNdOiAwHqBHZJdG SZTdrgx.JpLJgiLPaNd8HocdQGWC0FllQ5wmxviv2xGWX17ox3O9UfEZXvOd9Yg2HIhR8s2un3LA MrVfiDlyJgYdd94Y9ombuzRBeuL7p1rSF9DrCkgpbIzSzPHhJXtcJbYbpi8wXJ1QH4H0IocxmT0n qdlZpbaGbMT7uIVnELpgVE5k54MPvVg-- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic302.consmr.mail.ne1.yahoo.com with HTTP; Wed, 16 Jun 2021 19:21:56 +0000 Date: Wed, 16 Jun 2021 19:21:40 +0000 (UTC) From: LEROY TENNISON To: pgsql-admin Message-ID: <192101066.1663055.1623871300493@mail.yahoo.com> In-Reply-To: References: <1ltQeA-000URA-EE@unimaticaspa.it> Subject: Re: compression in replication MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1663054_427641003.1623871300492" X-Mailer: WebService/1.1.18469 YMailNorrin Content-Length: 3603 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1663054_427641003.1623871300492 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Keep in mind that this can be accomplished in other ways depending on what= archive_command you're using.=C2=A0 rsync, and sftp (I don't recommend scp= due to security concerns but it does compression as well) both have parame= ters to do in-transit compression.=C2=A0 If i remember correctly Postgresql= compression must be enabled on both ends.=C2=A0 I had a situation where th= at wasn't easy to do and opted for external (to Postgresql) compression. On Wednesday, June 16, 2021, 2:56:09 PM UTC, Vijaykumar Jain wrote: =20 =20 sorry, the link was broken. this was the param. "wal_compression (boolean) When this parameter is on, the PostgreSQL server compresses a full page image written to WAL when full_page_writes is on or during a base backup. A compressed page image will be decompressed during WAL replay. The default value is off. Only superusers can change this setting. Turning this parameter on can reduce the WAL volume without increasing the risk of unrecoverable data corruption, but at the cost of some extra CPU spent on the compression during WAL logging and on the decompression during WAL replay." =20 ------=_Part_1663054_427641003.1623871300492 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
Keep in mind that this can be accomplished in other ways depending on what archive_command you're using.  rsync, and sftp (I don't recommend scp due to security concerns but it does compression as well) both have parameters to do in-transit compression.  If i remember correctly Postgresql compression must be enabled on both ends.  I had a situation where that wasn't easy to do and opted for external (to Postgresql) compression.

On Wednesday, June 16, 2021, 2:56:09 PM UTC, Vijaykumar Jain <vijaykumarjain.github@gmail.com> wrote:


sorry, the link was broken.
this was the param.

"wal_compression (boolean)

When this parameter is on, the PostgreSQL server compresses a full
page image written to WAL when full_page_writes is on or during a base
backup. A compressed page image will be decompressed during WAL
replay. The default value is off. Only superusers can change this
setting.

Turning this parameter on can reduce the WAL volume without increasing
the risk of unrecoverable data corruption, but at the cost of some
extra CPU spent on the compression during WAL logging and on the
decompression during WAL replay."



------=_Part_1663054_427641003.1623871300492--