Re: pglz compression performance, take two - Mailing list pgsql-hackers

From Justin Pryzby
Subject Re: pglz compression performance, take two
Date
Msg-id 20210320051945.GQ11765@telsasoft.com
Whole thread Raw
In response to Re: pglz compression performance, take two  (Mark Dilger <mark.dilger@enterprisedb.com>)
Responses Re: pglz compression performance, take two
List 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 by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Replication slot stats misgivings
Next
From: Julien Rouhaud
Date:
Subject: Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?