| From: | Andrey Borodin <x4mmm(at)yandex-team(dot)ru> |
|---|---|
| To: | Tomas Vondra <tomas(at)vondra(dot)me> |
| Cc: | Ken Marshall <ktm(at)rice(dot)edu>, Hannu Krosing <hannuk(at)google(dot)com>, Andreas Karlsson <andreas(at)proxel(dot)se>, Christoph Berg <myon(at)debian(dot)org>, 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 08:34:23 |
| Message-ID: | A0D6CED4-F9FB-4A96-A433-E1C3B3CE501E@yandex-team.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Tomas, thanks for benchmarks! I agree that x2 WAL reduction actually makes Zstd
a good default when wal_compression = on.
> On 7 Aug 2026, at 13:23, Tomas Vondra <tomas(at)vondra(dot)me> wrote:
>
> 8.25% postgres libzstd.so.1.5.7 [.] ZSTD_createDCtx_internal
(sorry for offtopic)
That's an interesting profile.
Along with published patch to retain compression context we can also
retain decompression context. But that's for PG20 anyway.
Best regards, Andrey Borodin.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrey Borodin | 2026-08-07 08:47:47 | Re: Support specialized B-tree page searches |
| Previous Message | Tomas Vondra | 2026-08-07 08:23:15 | Re: WAL compression setting after PostgreSQL LZ4 default change |