Horton

Re: WAL compression setting after PostgreSQL LZ4 default change

Japin Li <japinli@hotmail.com>

View thread View on postgr.es
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>
Date: 2026-06-30T13:48:50Z
Lists: pgsql-hackers 
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.