Re: wal_compression=zstd - Mailing list pgsql-hackers

From Robert Haas
Subject Re: wal_compression=zstd
Date
Msg-id CA+Tgmob8sTKdTXG27O4dBriXg9m-yMc92winaU+3dvE2=5TMDQ@mail.gmail.com
Whole thread Raw
In response to Re: wal_compression=zstd  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: wal_compression=zstd  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
On Fri, Mar 4, 2022 at 6:44 AM Justin Pryzby <pryzby@telsasoft.com> wrote:
> > Why?  ZSTD using this default has its reasons, no?  And it would be
> > consistent to do the same for ZSTD as for the other two methods.
>
> In my 1-off test, it gets 610/633 = 96% of the benefit at 209/273 = 77% of the
> cost.

I agree with Michael. Your 1-off test is exactly that, and the results
will have depended on the data you used for the test. I'm not saying
we could never decide to default to a compression level other than the
library's default, but I do not think we should do it casually or as
the result of any small number of tests. There should be a strong
presumption that the authors of the library have a good idea what is
sensible in general unless we can explain compellingly why our use
case is different from typical ones.

There's an ease-of-use concern here too. It's not going to make things
any easier for users to grok if zstd is available in different parts
of the system but has different defaults in each place. It wouldn't be
the end of the world if that happened, but neither would it be ideal.

-- 
Robert Haas
EDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Gilles Darold
Date:
Subject: Re: [Proposal] vacuumdb --schema only
Next
From: Andrew Dunstan
Date:
Subject: Re: wal_compression=zstd