| From: | Christoph Berg <myon(at)debian(dot)org> |
|---|---|
| To: | Tomas Vondra <tomas(at)vondra(dot)me> |
| Cc: | Michael Paquier <michael(at)paquier(dot)xyz>, 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>, 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-09 17:25:26 |
| Message-ID: | ani4BpccmFfbO9dq@msg.df7cb.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Re: Tomas Vondra
> + The supported methods are <literal>off</literal>, <literal>on</literal>,
> + <literal>lz4</literal> (if <productname>PostgreSQL</productname> was compiled with <option>--with-lz4</option>),
> + <literal>zstd</literal> (if <productname>PostgreSQL</productname> was compiled with <option>--with-zstd</option>), and
> + <literal>pglz</literal>.
> + The value <literal>on</literal> selects the first of <literal>zstd</literal>,
> + <literal>lz4</literal>, <literal>pglz</literal> that is available.
> #wal_compression = off # enables compression of full-page writes;
> - # off, pglz (or "on"), lz4, or zstd
> + # off, on, lz4, zstd, or pglz (on means the first
> + # of zstd, lz4 and pglz, supported by the build)
I would put zstd before lz4 in both places as it's preferred over it.
Christoph
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan S. Katz | 2026-08-09 17:39:30 | 2026-08-13 release announcement draft |
| Previous Message | Rui Zhao | 2026-08-09 16:45:40 | Re: pg_rewind: Skip vanished source files during traversal |