| From: | Hannu Krosing <hannuk(at)google(dot)com> |
|---|---|
| To: | Andreas Karlsson <andreas(at)proxel(dot)se> |
| Cc: | 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 13:36:36 |
| Message-ID: | CAMT0RQTJAEhXZQtLKZPs=ZSv5LVGHgO_X23boNmj89-CYxDs=A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
For the CPU usage vs compression ratio discussion, please remember
that for both lz4 and zstd this depends on certain "compression
effort" flags, which we do not expose to customers (we claim we
already choose the best ones for them :) )
To have a good basis for any recommendation someone could run a bunch
of tests with different compression level flags and compare the
results for CPU usage and compression ration for 8kB pages.
On Mon, Aug 3, 2026 at 10:26 AM Andreas Karlsson <andreas(at)proxel(dot)se> wrote:
>
> 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 | |
|---|---|---|---|
| Previous Message | Andrey Borodin | 2026-08-03 13:12:35 | Re: [WiP] GiST intrapage indexing |