Horton

Re: WAL compression setting after PostgreSQL LZ4 default change

wenhui qiu <qiuwenhuifx@gmail.com>

View thread View on postgr.es
From: wenhui qiu <qiuwenhuifx@gmail.com>
To: Christoph Berg <myon@debian.org>, Jelte Fennema-Nio <postgres@jeltef.nl>, Michael Paquier <michael@paquier.xyz>, Japin Li <japinli@hotmail.com>, Fujii Masao <masao.fujii@gmail.com>, wenhui qiu <qiuwenhuifx@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>, John Naylor <johncnaylorls@gmail.com>
Date: 2026-07-08T06:37:36Z
Lists: pgsql-hackers 
Hi

> I would like to see "on" to be moved to some better value (likely lz4,
> > like toast compression), and if some day, there is yet a better
> > choice, we should move it again.
> Yes, After PostgreSQL 19, lz4 became a required dependency unless you
> compile it yourself with --without-lz4. In most environments, lz4 is
> already installed, so along this code path the effective choice is
> essentially fixed to lz4.At cluster scale, it would make more sense to
> expose this parameter in the frontend as a boolean setting, rather than
> letting users choose from multiple compression options.


Thanks