Re: change default default_toast_compression to lz4?

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>
To: Peter Eisentraut <peter@eisentraut.org>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2025-11-26T04:35:08Z
Lists: pgsql-hackers
On Fri, Nov 21, 2025 at 12:11:38PM +0100, Peter Eisentraut wrote:
> I suppose one issue is that lz4 support is not compiled-in by default, but
> in practice most users will have it.  The default could be lz4 if lz4
> support is built, otherwise pglz.  This would be similar to other parameters
> where the default is the best one depending on the build configuration.

+1.  That makes sense here to flip the default depending on what the
code is built with, with lz4 if available, pglz otherwise.
--
Michael