Re: change default default_toast_compression to lz4?

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Peter Eisentraut <peter(at)eisentraut(dot)org>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: change default default_toast_compression to lz4?
Date: 2025-11-26 04:35:08
Message-ID: aSaDfIrZIhZwAe42@paquier.xyz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2025-11-26 04:54:03 Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem)
Previous Message Pavel Stehule 2025-11-26 04:29:46 Re: [PATCH] Add mssql_compat extension with DATEDIFF function