Re: change default default_toast_compression to lz4? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: change default default_toast_compression to lz4?
Date
Msg-id 2206880.1763741781@sss.pgh.pa.us
Whole thread Raw
In response to Re: change default default_toast_compression to lz4?  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> On 2025-11-21 12:11:38 +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.

> I think we should mark lz4 as a default-required dependency if we change the
> default. That way one needs to explicitly opt into a build that won't be
> compatible with existing data directories created (due to pre-existing lz4 .

Agreed --- we should make it act like icu or readline, you have to
opt out.  (I'm not voting one way or the other on changing the
default, but if we do we should do it that way.)

            regards, tom lane



pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Allow GUC settings in CREATE SUBSCRIPTION CONNECTION to take effect
Next
From: Jacob Champion
Date:
Subject: Re: RFC 9266: Channel Bindings for TLS 1.3 support