| From: | Andreas Karlsson <andreas(at)proxel(dot)se> |
|---|---|
| To: | Tomas Vondra <tomas(at)vondra(dot)me>, Christoph Berg <myon(at)debian(dot)org>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, 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-03 08:26:10 |
| Message-ID: | fb536abd-9785-4320-9aa4-658617356c66@proxel.se |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 7/31/26 23:44, Tomas Vondra wrote:
> As for the zstd vs. lz4 - the patch put zstd first mostly because
> Michael prefers it over lz4. I don't think either of these is superior.
> AFAIK the algorithms make different trade offs - zstd tends to compress
> better, but uses (substantially) more CPU. I think it makes sense to
> default to lz4, it's clearly better than pglz, with low CPU usage.
+1 I think lz4 is the more sensible default due to the low CPU usage.
--
Andreas Karlsson
Percona
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Korotkov | 2026-08-03 08:32:31 | Re: Asynchronous MergeAppend |
| Previous Message | Chao Li | 2026-08-03 07:47:09 | Re: A new C function `get_partition_root`. |