| From: | Christoph Berg <myon(at)debian(dot)org> |
|---|---|
| To: | Tomas Vondra <tomas(at)vondra(dot)me> |
| Cc: | 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>, pgsql-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-07 20:27:04 |
| Message-ID: | anY_mPKGboIMTFS2@msg.df7cb.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
(As said above I don't think "PG 19: toast lz4, wal zstd" is bad, the
important bit is "PG 19 is switching toast and wal away from pglz",
that is the message we should put into the release notes.)
Christoph
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nathan Bossart | 2026-08-07 21:36:20 | Re: Why is_admin_of_role() use ROLERECURSE_MEMBERS rather than ROLERECURSE_PRIVS? |
| Previous Message | Tomas Vondra | 2026-08-07 20:09:46 | Re: WAL compression setting after PostgreSQL LZ4 default change |