Re: WAL compression setting after PostgreSQL LZ4 default change

Поиск
Список
Период
Сортировка
Искать
От
wenhui qiu
Тема
Re: WAL compression setting after PostgreSQL LZ4 default change
Дата
в 10:15:19
Msg-id
CAGjGUA+rT0OczFZFSX0qgnfwbxWhzva+xKOQQzqj4e3KtjTkmg@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 

> Based on this, I agree with the original suggestion to default to
>    zstd > lz4 > pglz
> I don't think we need to "tune" the compression levels for either of the
> algorithms. The defaults seem pretty reasonable.

Thank you for your test , It looks like Michael Paquier's suggestion was right—zstd doesn't have much difference in CPU consumption at default compression levels, and it achieves a higher compression ratio. On another note, I recall there was a patch discussing zstd compression for TOAST, but it hasn't been active for a long time. Since zstd offers a higher compression ratio, I think it's worth pushing this forward.


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