Re: change default default_toast_compression to lz4?

On Wed, Nov 26, 2025, at 1:35 AM, Michael Paquier wrote:
> 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.
>

Since we have an agreement that $SUBJECT is ok, I wrote a patch for it. It
selects the compression method based on USE_LZ4. It also adjusts the
postgresql.conf if required.


-- 
Euler Taveira
EDB   https://www.enterprisedb.com/