pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Justin Pryzby <pryzby@telsasoft.com>
To: Mark Dilger <mark.dilger@enterprisedb.com>
Cc: Andrey Borodin <x4mmm@yandex-team.ru>
Cc: pgsql-hackers@postgresql.org
Subject: Re: pglz compression performance, take two
Date: Sat, 20 Mar 2021 00:19:45 -0500
Message-ID: <20210320051945.GQ11765@telsasoft.com> (raw)
In-Reply-To: <91F7608D-4800-49B8-B5EC-911AAF1BB069@enterprisedb.com>
References: <FEF3DC5E-4BC4-44E1-8DEB-DADC67046FE3@yandex-team.ru>
	<D75ABE30-2AAA-47DB-A89F-665E03BAAD2A@yandex-team.ru>
	<25991595-1848-4178-AA57-872B10309DA2@yandex-team.ru>
	<20201230043930.GG25152@telsasoft.com>
	<BF0A7E6D-AB21-47F8-A5FA-328CAA32DB12@yandex-team.ru>
	<20210122024811.GE27167@telsasoft.com>
	<B471542B-A190-4491-8E92-C196861B3589@yandex-team.ru>
	<91F7608D-4800-49B8-B5EC-911AAF1BB069@enterprisedb.com>

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





view thread (32+ messages)  latest in thread

Message-ID: <20210320051945.GQ11765@telsasoft.com>
Permalink:  ../20210320051945.GQ11765@telsasoft.com/
Also on:    postgresql.org/message-id/20210320051945.GQ11765@telsasoft.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: pryzby@telsasoft.com, mark.dilger@enterprisedb.com, x4mmm@yandex-team.ru
  Subject: Re: pglz compression performance, take two
  In-Reply-To: <20210320051945.GQ11765@telsasoft.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox