Re: WAL compression setting after PostgreSQL LZ4 default change
От
wenhui qiu
Тема
Re: WAL compression setting after PostgreSQL LZ4 default change
Дата
Msg-id
CAGjGUALBMSzJ=ngL0k0CR6MqM+1W=Y+=+MSv+Z4R5jvmr47P5A@mail.gmail.com
Ответ на
Re: WAL compression setting after PostgreSQL LZ4 default change (Christoph Berg)
Список
Дерево обсуждения
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,lz4became a required dependency unless you compile it yourself with--without-lz4. In most environments,lz4is already installed, so along this code path the effective choice is essentially fixed tolz4.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
Дата: