| From: | Daniel Gustafsson <daniel(at)yesql(dot)se> |
|---|---|
| To: | Christoph Berg <myon(at)debian(dot)org> |
| Cc: | 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>, Jelte Fennema-Nio <postgres(at)jeltef(dot)nl>, 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 19:30:22 |
| Message-ID: | 0ABD11F6-A25B-42CC-97B6-85C9C6E97FF2@yesql.se |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> 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.
--
Daniel Gustafsson
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jelte Fennema-Nio | 2026-08-08 20:57:55 | Re: WAL compression setting after PostgreSQL LZ4 default change |
| Previous Message | solai v | 2026-08-08 19:29:29 | Re: postgres_fdw: Emit message when batch_size is reduced |