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

From Euler Taveira
Subject Re: change default default_toast_compression to lz4?
Date
Msg-id c822b84c-b104-4fb4-92f3-3008cce50bf9@app.fastmail.com
Whole thread Raw
In response to Re: change default default_toast_compression to lz4?  (Michael Paquier <michael@paquier.xyz>)
Responses Re: change default default_toast_compression to lz4?
List pgsql-hackers
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/
Attachment

pgsql-hackers by date:

Previous
From: Álvaro Herrera
Date:
Subject: Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY
Next
From: Dmitry Dolgov
Date:
Subject: Re: System views for versions reporting