public inbox for [email protected]  

help / color / mirror / Atom feed

From: Jelte Fennema-Nio <[email protected]>
To: Michael Paquier <[email protected]>
Cc: Japin Li <[email protected]>
Cc: Fujii Masao <[email protected]>
Cc: wenhui qiu <[email protected]>
Cc: pgsql-hackers <[email protected]>
Cc: John Naylor <[email protected]>
Cc: Christoph Berg <[email protected]>
Subject: Re: WAL compression setting after PostgreSQL LZ4 default change
Date: Wed, 8 Jul 2026 00:46:53 +0200
Message-ID: <CAGECzQQ+OWP+yafyUp_g3DDY-cKYoyATUEJRkgatLU6n70kH_A@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAGjGUAL1b=Mwd1SCvLbo+fivEr9KDpFcu4jmqKCZXwT=6CiiGQ@mail.gmail.com>
	<[email protected]>
	<CAHGQGwGv8FLvOkTm3dpTsvt70puYpzKOmq3-YQSOpDCdZ8gyaQ@mail.gmail.com>
	<SY7PR01MB1092134E0AD4108661A3A65F8B6F42@SY7PR01MB10921.ausprd01.prod.outlook.com>
	<[email protected]>

On Wed, 8 Jul 2026 at 00:26, Michael Paquier <[email protected]> wrote:
> I disagree.  The whole argument is that most users don't bother
> changing the defaults.  Here, a change between lz4/zstd and pglz is
> like day and night; folks are going to see improvements all the time
> if we switch to a better default when we can, in terms of CPU, memory
> and IO.

A small correction though: "on" isn't the default. The default is
"off". So this would only impact users who changed the setting in
their cluster to "on" at some point in the past when lz4/zstd support
did not exist yet. So we wouldn't be changing the default. We'd be
changing the behavior for people who changed their default setting at
some point.

To be clear, I agree with you that that's a reasonable thing to do; I
don't think any of those people actually want to burn CPU for no
reason. So they'd all be happy if we stopped doing that. pglz
basically has no right to be used anywhere in production systems IMO.

view thread (12+ messages)  latest in thread

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: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: WAL compression setting after PostgreSQL LZ4 default change
  In-Reply-To: <CAGECzQQ+OWP+yafyUp_g3DDY-cKYoyATUEJRkgatLU6n70kH_A@mail.gmail.com>

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

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