change default default_toast_compression to lz4?

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: change default default_toast_compression to lz4?
Date: 2025-11-21 11:11:38
Message-ID: 435df33a-129e-4f0c-a803-f3935c5a5ecb@eisentraut.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

How about changing the default of default_toast_compression to lz4?

I have seen cases where servers had performance problems and were
CPU-bound because of pglz TOAST compression, and changing it to lz4
relieved it significantly. I suspect many users are leaving easy
performance improvements on the table by not using this option.

The feature was introduced in PostgreSQL 14, so it should be well
stabilized now.

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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Aleksander Alekseev 2025-11-21 11:33:38 Re: change default default_toast_compression to lz4?
Previous Message Peter Eisentraut 2025-11-21 10:48:10 headerscheck ccache support