Horton

Re: WAL compression setting after PostgreSQL LZ4 default change

Christoph Berg <myon@debian.org>

View thread View on postgr.es
From: Christoph Berg <myon@debian.org>
To: wenhui qiu <qiuwenhuifx@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>, Japin Li <japinli@hotmail.com>, John Naylor <johncnaylorls@gmail.com>, Michael Paquier <michael@paquier.xyz>
Date: 2026-06-30T10:51:13Z
Lists: pgsql-hackers 
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.

Christoph