change default default_toast_compression to lz4?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема change default default_toast_compression to lz4?
Дата
Msg-id 435df33a-129e-4f0c-a803-f3935c5a5ecb@eisentraut.org
обсуждение исходный текст
Ответы Re: change default default_toast_compression to lz4?
Re: change default default_toast_compression to lz4?
Список 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.




В списке pgsql-hackers по дате отправления: