Re: WAL compression setting after PostgreSQL LZ4 default change

From: Jelte Fennema-Nio <postgres(at)jeltef(dot)nl>
To: Daniel Gustafsson <daniel(at)yesql(dot)se>
Cc: Christoph Berg <myon(at)debian(dot)org>, Tomas Vondra <tomas(at)vondra(dot)me>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, Ken Marshall <ktm(at)rice(dot)edu>, Hannu Krosing <hannuk(at)google(dot)com>, Andreas Karlsson <andreas(at)proxel(dot)se>, wenhui qiu <qiuwenhuifx(at)gmail(dot)com>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Andres Freund <andres(at)anarazel(dot)de>, Michael Paquier <michael(at)paquier(dot)xyz>, Japin Li <japinli(at)hotmail(dot)com>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, John Naylor <johncnaylorls(at)gmail(dot)com>
Subject: Re: WAL compression setting after PostgreSQL LZ4 default change
Date: 2026-08-08 20:57:55
Message-ID: CAGECzQSVhJ3irgX1hTcPTvRuHvdUZ6LwfomVDBfPeeW1Y0ZeLA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Aug 8, 2026, 21:30 Daniel Gustafsson <daniel(at)yesql(dot)se> wrote:

> > On 7 Aug 2026, at 22:27, Christoph Berg <myon(at)debian(dot)org> wrote:
> >
> > Re: Tomas Vondra
> >> The question is what does this mean for this thread, i.e. for the
> >> question what should 'on' translate to. I still think zstd seems like a
> >> better default, despite this one result where lz4 does a bit better.
> >> Especially if we know it the difference can be mostly eliminated.
> >
> > To me, this doesn't read like a question but a confirmation that zstd
> > is the correct pick. They are close now, we tend to prefer zstd, and
> > now we know how to make zstd even better in PG 20, then it looks clear
> > that zstd is the "on" to go so we aren't switching twice.
>
> I tend to agree with this reasoning.
>

+1

>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bharath Rupireddy 2026-08-08 21:17:00 Re: [PATCH] Release replication slot on error in SQL-callable slot functions
Previous Message Daniel Gustafsson 2026-08-08 19:30:22 Re: WAL compression setting after PostgreSQL LZ4 default change