Re: pglz compression performance, take two

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: pglz compression performance, take two
Дата
Msg-id 20210320051945.GQ11765@telsasoft.com
обсуждение исходный текст
Ответ на Re: pglz compression performance, take two  (Mark Dilger <mark.dilger@enterprisedb.com>)
Ответы Re: pglz compression performance, take two  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
On Fri, Mar 19, 2021 at 01:29:14PM -0700, Mark Dilger wrote:
> Robert Haas just committed Dilip Kumar's LZ4 compression, bbe0a81db69bd10bd166907c3701492a29aca294.
> 
> Is this pglz compression patch still relevant?  How does the LZ4 compression compare on your hardware?

I think it's still relevant, since many people may not end up with binaries
--with-lz4 (I'm thinking of cloud providers).  PGLZ is what existing data uses,
and people may not want to/know to migrate to shiny new features, but they'd
like it if their queries were 20% faster after upgrading without needing to.

Also, Dilip's patch is only for TOAST compression, and pglz is also being used
for wal_compression - Andrey has a short patch to implement lz4 for that:
https://commitfest.postgresql.org/32/3015/

-- 
Justin



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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Replication slot stats misgivings
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?