From: Michael Paquier <michael@paquier.xyz>
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: Andrey Borodin <x4mmm@yandex-team.ru>
Cc: pgsql-hackers@postgresql.org, Thomas Munro <thomas.munro@gmail.com>
Subject: Re: Different compression methods for FPI
Date: Tue, 25 May 2021 16:26:42 +0900
Message-ID: <YKymshLnYZeD0cue@paquier.xyz> (raw)
In-Reply-To: <20210525044444.GV3676@telsasoft.com>
References: <20210312074547.GQ8796@telsasoft.com>
<20210313012820.GJ29463@telsasoft.com>
<BEF3B1E0-0B31-4F05-8E0A-F681CB918626@yandex-team.ru>
<20210315003135.GL29463@telsasoft.com>
<20210315180918.GW29463@telsasoft.com>
<20210321193004.GA4203@telsasoft.com>
<YKIelANwse+k2JxT@paquier.xyz>
<20210519030618.GS373@telsasoft.com>
<YKTa4+kTFkb3EIBs@paquier.xyz>
<20210525044444.GV3676@telsasoft.com>
On Mon, May 24, 2021 at 11:44:45PM -0500, Justin Pryzby wrote:
> The goal is to support 2+ "methods" (including "none"), which takes 4 bits, so
> may as well support 3 methods.
>
> - uncompressed
> - pglz
> - lz4
> - zlib or zstd or ??
Let's make a proper study of all that and make a choice, the only
thing I am rather sure of is that pglz is bad compared to all the
others. There is no point to argue as long as we don't know if any of
those candidates are suited for the job.
> This version:
> 0) repurposes the pre-existing GUC as an enum;
> 1) saves a bit (until zstd is included);
> 2) shows the compression in pg_waldump;
>
> To support different compression levels, I think I'd change from an enum to
> string and an assign hook, which sets a pair of ints.
Hmm. I am not really sure what you mean here, but let's keep that
in mind until we get more performance numbers.
--
Michael
Attachments:
signature.asc (application/pgp-signature, 832B) download
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: michael@paquier.xyz, pryzby@telsasoft.com, x4mmm@yandex-team.ru, thomas.munro@gmail.com
Subject: Re: Different compression methods for FPI
In-Reply-To: <YKymshLnYZeD0cue@paquier.xyz>
* 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