Re: WAL compression setting after PostgreSQL LZ4 default change - Mailing list pgsql-hackers

From Japin Li
Subject Re: WAL compression setting after PostgreSQL LZ4 default change
Date
Msg-id SY7PR01MB109213B454FC3A6893980C17BB6F72@SY7PR01MB10921.ausprd01.prod.outlook.com
Whole thread
List 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.



pgsql-hackers by date:

Previous
From: Álvaro Herrera
Date:
Subject: Re: DROP INVALID INDEXES command
Next
From: Peter Eisentraut
Date:
Subject: Re: Make SPI_prepare argtypes argument const