Re: WAL compression setting after PostgreSQL LZ4 default change

Поиск
Список
Период
Сортировка
Искать
От
wenhui qiu
Тема
Re: WAL compression setting after PostgreSQL LZ4 default change
Дата
в 09:37:36
Msg-id
CAGjGUALBMSzJ=ngL0k0CR6MqM+1W=Y+=+MSv+Z4R5jvmr47P5A@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Re: WAL compression setting after PostgreSQL LZ4 default change Laurenz Albe <laurenz.albe@cybertec.at>
Re: WAL compression setting after PostgreSQL LZ4 default change wenhui qiu <qiuwenhuifx@gmail.com>
Re: WAL compression setting after PostgreSQL LZ4 default change Christoph Berg <myon@debian.org>
Hi 

> I would like to see "on" to be moved to some better value (likely lz4,
> like toast compression), and if some day, there is yet a better
> choice, we should move it again.
Yes, After PostgreSQL 19, lz4 became a required dependency unless you compile it yourself with --without-lz4. In most environments, lz4 is already installed, so along this code path the effective choice is essentially fixed to lz4.At cluster scale, it would make more sense to expose this parameter in the frontend as a boolean setting, rather than letting users choose from multiple compression options.

Thanks 
В списке pgsql-hackers по дате отправления
От: Michael Paquier
Дата:
От: Michael Paquier
Дата:
FAQ