Date: Tue, 30 Jun 2026 12:51:13 +0200
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>
Subject: Re: WAL compression setting after PostgreSQL LZ4 default change
Message-ID: <akOfoQCqMrXGx5UJ@msg.df7cb.de>
Mail-Followup-To: Christoph Berg <myon@debian.org>,
	wenhui qiu <qiuwenhuifx@gmail.com>,
	pgsql-hackers <pgsql-hackers@postgresql.org>,
	Japin Li <japinli@hotmail.com>,
	John Naylor <johncnaylorls@gmail.com>,
	Michael Paquier <michael@paquier.xyz>
References: 
 <CAGjGUAL1b=Mwd1SCvLbo+fivEr9KDpFcu4jmqKCZXwT=6CiiGQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAGjGUAL1b=Mwd1SCvLbo+fivEr9KDpFcu4jmqKCZXwT=6CiiGQ@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/akOfoQCqMrXGx5UJ%40msg.df7cb.de>
Precedence: bulk

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