From: Japin Li <japinli@hotmail.com>
To: Christoph Berg <myon@debian.org>
Cc: wenhui qiu <qiuwenhuifx@gmail.com>,  pgsql-hackers
 <pgsql-hackers@postgresql.org>,  John Naylor <johncnaylorls@gmail.com>,
  Michael Paquier <michael@paquier.xyz>
Subject: Re: WAL compression setting after PostgreSQL LZ4 default change
In-Reply-To: <akOfoQCqMrXGx5UJ@msg.df7cb.de> (Christoph Berg's message of
	"Tue, 30 Jun 2026 12:51:13 +0200")
References: 
 <CAGjGUAL1b=Mwd1SCvLbo+fivEr9KDpFcu4jmqKCZXwT=6CiiGQ@mail.gmail.com>
	<akOfoQCqMrXGx5UJ@msg.df7cb.de>
User-Agent: mu4e 1.14.1; emacs 30.2
Date: Tue, 30 Jun 2026 21:48:50 +0800
Message-ID: 
 <SY7PR01MB109213B454FC3A6893980C17BB6F72@SY7PR01MB10921.ausprd01.prod.outlook.com>
Content-Type: text/plain
MIME-Version: 1.0
X-MS-Exchange-MessageSentRepresentingType: 1
X-MS-PublicTrafficType: Email
X-MS-TrafficTypeDiagnostic: SY7PR01MB10921:EE_|ME5PR01MB9971:EE_
X-MS-Office365-Filtering-Correlation-Id: 64f66cf5-7cad-453a-7779-08ded6ae52f3
X-MS-Exchange-SLBlob-MailProps: 
	AZnQBsB9XmrTkIzDOCxR6E7nJ4I/6XZ70pE50TeU/Wdh5KtL5zgbo3uoDdVptRC9Z/cuautB9P5YV2hKOTCC3gtLJPHxUoiIKfAxovDYP/CbgLbYsFqggmWtejdYUifaCwtqM7bs2JS4WqNNLLZ37E451F6MGHdz5ytM3QPOUyFaQG8zAZNm4e3dv9Hi/3SvUlsg45yOkLz03994kkq7lba9itOmqWwSngNONrN12JWEzne5kFIyw4jDZVx0Eaasm6O+R+RaQDPaRZcGZXMGlPqr8Zcwi6WyXcguM5NGI96dgtasXI/u1adUB59pTsVGVYXeV1Vttap700nw+rvOhV0l7sekOUPOv3G8GJShVZM27fKjgkZYjftUwAbn410nQp5/fD5RMCaKmHdz1ETMh4GHZwtqtzC53JqTGVEO9BsogXQLgY4z0DKtCfqE1uMbmcJJ0loDr/TZMllBR+tgO4e+d6GMndv8NwIHW+k10aCoyGjcSj7IQF32TwpPMfX5CpBmaeuBloSJAQsZ5sEIAU5gjh5cSAkg8B8bwkzJa1lXDAA6PXCvhe53xypNN9dqtZNhICwKuo5qZUftXnnNDd8Y3UsbUrjnYCY8pf2+ffMnGUFiXRM0+k9sT0DjjWGE3Ch9jF/GDV12evyyPq3wQHrYlZFdMltBbWw7AGuKSJruEEnv+apLQ1n95MzPydQOpb1QRMHz4Pj8Z06O98DCOVSHcT0jjTDR1y+XB3/QkUnMkERZ4qrjiJ5MNNnlCN8EbM71JFexYbw=
X-Microsoft-Antispam: 
	BCL:0;ARA:14566002|24121999003|22091999003|5072599009|8060799015|25010399006|4140399003|24021099003|55001999006|23021999003|15080799012|19110799012|440099028|3412199025|40105399003|52005399003|26121999007;
X-Microsoft-Antispam-Message-Info: 
	=?us-ascii?Q?HOQ4fh8bOyzwCWzdjya0kEzBLC2d+ApwvmRBSRAbFbSTDhuo0R7NEP1dAGgJ?=
 =?us-ascii?Q?kB5qSl3EjlxOC9qLZ3+8UXj0YshO4MIAlyg56koW0avKMth1QuhT1vym/FZz?=
 =?us-ascii?Q?UBTWmyjTz+Ln2z2e9F9RNpo0+SlpW8ec3yFa8aB1FdVKYUKkd/z9AaS43kE7?=
 =?us-ascii?Q?D4qNy6QbfVYs3bVL8RQMas3CvdX0RlAvqvZcE5kPDOZoQhIYdRrHJJVX1T0T?=
 =?us-ascii?Q?eIYe5Sk/T1Q3/wgHL5CtOIQ8TDzYsvwhssXmOpsMJAfMQ9veSoAWeJfOBO5S?=
 =?us-ascii?Q?833x+WC8HiKIuM/d4LAE+vGvpcxW9OttJ3IC+DKc7TGkG+iOF9PCgmRhcQ8Z?=
 =?us-ascii?Q?kWYm6agjgh5crCum9VxPGmfiqqOio0Zqf8IdgUYRoR9m8XUaK3J7Jsl4ZEkX?=
 =?us-ascii?Q?Zo8l3cBY43hfdQu5ISmWQWr3PGFKc0vnLJ8Obe8Nz9zy7678+IPdlpFbMInC?=
 =?us-ascii?Q?mA86W7rkMRONyDUNE44OFIdPWX6b1L0vjqVWQjanQuGtgFDP7HxxrhQPGILj?=
 =?us-ascii?Q?rdCRa2uklLOVsq/LBjf2+I46/juQcl2RZIg9fpIRbjbXcHSNHeMTmn2y3Odw?=
 =?us-ascii?Q?EFJ9PSLR8HiDOWOFeO2PmT0RKRha+GTFL4+oRTS5ChJsRt0BssRjkumyWYg/?=
 =?us-ascii?Q?H1UTzXKDT0foeeadyRxxgly3QoaQ8/3dRGP68uyzQ5UuhDnI+WL1Th8XXcsp?=
 =?us-ascii?Q?7EDZv17M86joqiSYk4zh9kX1yocvyJM370U5KWR0zPRZHsOTPhr0IMAp3mQt?=
 =?us-ascii?Q?GJSRTkQ7/xUU2UgmMGHx079frW9vE67Y1Z7chn8ZsPncfmfc9Hbo4lDIIebm?=
 =?us-ascii?Q?eLDnAfuSzDaW+TWtFQJi3Vcu9c/pjQrz+EnYBaGL0s74KCJ997ZE/2xEmhoX?=
 =?us-ascii?Q?V3YVrbLKpbym7qQlH7hVQHozB2qH3OSPQLWT10xSfSL2mGouiqzeM06Jn79w?=
 =?us-ascii?Q?Pvb8NuRIuLbTuleRlLUoV4pJ0mND+ZdD12zii9r8L9w/orGhZ0tm/ScDW3Ux?=
 =?us-ascii?Q?H6VUhFeny15z0XVXkjWh7F4SZVaH6bzn98hNHcr8Xb1YC1l1fUGmD8IJtzjR?=
 =?us-ascii?Q?xnSyr+MA?=
X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-MessageData-0: 
	=?us-ascii?Q?nsxRaIyfH2KLZ/lPETNjAOcSzem5WWSxOcCYwVwgijgHEktQngcjE1STwyun?=
 =?us-ascii?Q?jOJrwAY/M1s60LSFwWJ+sdxGqR8obi5+SqYcomN84ebvRSN2G5pNUTr2c9Ai?=
 =?us-ascii?Q?yddfkeIW1lLeSDGnknPY9M0WMhVA/Ti6EvN4zPLUwL9wmDINJib1P0StED+K?=
 =?us-ascii?Q?jL0Usi9R9RMgx7pkTlmpNcat1DEDcbCaoKDBeTzFAPMu6fucQM7PZX9V+nIS?=
 =?us-ascii?Q?grNNcT1aUAh4F+g+qHCynkgfXXyC2CUSQ2qmOyHioIFcBXWhiWFkAmIa1Lir?=
 =?us-ascii?Q?KF3dtA/CtYbg1N3QuVh24eIKZA8qfh7Lcb9N6CRJMsvYzwrb52R1LIqSDJ0o?=
 =?us-ascii?Q?DEUC/2i0US87yI5a9IS/XOf9zgbYRo9+w9Ssnidezfcimz7RfqeIB+/5gg0M?=
 =?us-ascii?Q?CZ9qkCl8xdKCUgN3eD78BWS0pbiO+uDd7Ji4f3YBNH7WzVGSGAyVPjQ5CeRx?=
 =?us-ascii?Q?fDf8DfVDTnT4quNuxbv714Su4La6/brM9fkwX3NHr/fyIeMwSbdaAGFiWxnd?=
 =?us-ascii?Q?nBlGPsfyTkgh83/TEPJBPLrcPhD5cGIO/P8iJRpjyUFff+XP0HHS4yQgy0Fu?=
 =?us-ascii?Q?clr2ZYLn53bgQP3iTnIiAHfEr5hIwID2K+DMiGv4mQ8RnscCmMnVh4ERn/jN?=
 =?us-ascii?Q?t4YmwwCN2MRcj9Dck0j9aG2OGRkKQBHgHKjAF0eZknjxoc8Nme8jfG9K0Zkw?=
 =?us-ascii?Q?PyS0RLSK99I46CoFqZ2os1b6+9X73Gbo3m33IAD6IOoN4ZnjJYpomcsygScj?=
 =?us-ascii?Q?V5bwy6VwG6lvG1H33FmWGDXcnpGmyMSp21WKVjm/YfkadfEPJnWR3U9mDWc4?=
 =?us-ascii?Q?OUUW+rnU1gCUPjblZPa/G+Jz5Wxf4G8c63dgg4lwKxZCWLmYd41w9zanU1sx?=
 =?us-ascii?Q?H5WXt0J2mHfbl5WxOTcnbYWb+Ea+HO9TLd53/CBzuMtVE9bG/e/JUH5iz8Fa?=
 =?us-ascii?Q?wbaHY6YzMmzrZOSmbSdAKiR5WKpq1BjFK23g3LwM40Bns87BotW4A8Qtv9Fc?=
 =?us-ascii?Q?B4dMhbhwUbQMKwyO6G3uRqOJFsaq9NzFAKEp86ha8WZRnekEkzFq1QPgXimn?=
 =?us-ascii?Q?4vDISCaWz4hjbjSFlCDVNR/wpu8SLh57r5HSInNXqVL0CijW5VO+qrWxCWHR?=
 =?us-ascii?Q?VfsCNBeJFL2Vg74cqk2/tgc5VVGzZ5+AYEGQi/lEiyhVXO6MeOp+tqj6oM8y?=
 =?us-ascii?Q?W6Ela7OrWsckgXlBKj0BJPIrFRuct1Lqy3ck0fB2Q849PFNgsbPsaQRoABeu?=
 =?us-ascii?Q?w7ww+/wy6Kln9qAdCdSrLQK3vUmNfA+uEoKKntTtDF3FOK4KdAau9cz0AZKs?=
 =?us-ascii?Q?xDi86jr5PzQi2+uU40LP14O7hH8Z9d5vhtEm0+SmVNRKqFXf0I4T43SByEeJ?=
 =?us-ascii?Q?xZPmXICHK0uHMYFGTqxSQO0+xpQ+?=
X-OriginatorOrg: sct-15-20-9412-4-msonline-outlook-feddd.templateTenant
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 64f66cf5-7cad-453a-7779-08ded6ae52f3
X-MS-Exchange-CrossTenant-AuthSource: SY7PR01MB10921.ausprd01.prod.outlook.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 30 Jun 2026 13:48:53.9200
 (UTC)
X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted
X-MS-Exchange-CrossTenant-Id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 
	00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: ME5PR01MB9971
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/SY7PR01MB109213B454FC3A6893980C17BB6F72%40SY7PR01MB10921.ausprd01.prod.outlook.com>
Precedence: bulk

On Tue, 30 Jun 2026 at 12:51, Christoph Berg <myon@debian.org> wrote:
> Re: wenhui qiu
>> The recent PostgreSQL commit changes the default TOAST compression to lz4
>> when LZ4 support is available, based on the rationale that LZ4 is generally
>> more efficient than pglz in terms of CPU usage and compression ratio.Given
>> that, should we also consider changing the default compression method used
>> by wal_compression = on from pglz to lz4?
>
> +1 from me. I would prefer this patch over the doc-only one that I
> sent in the other thread.
>
> This should go into PG19 so we don't have two different versions that
> flip the default from pglz to lz4.
>

+1.  LGTM.

> Christoph

-- 
Regards,
Japin Li
ChengDu WenWu Information Technology Co., Ltd.