agora inbox for pgsql-hackers@postgresql.org
help / color / mirror / Atom feedFrom: Christoph Berg <myon@debian.org>
To: Tomas Vondra <tomas@vondra.me>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: Andrey Borodin <x4mmm@yandex-team.ru>
Cc: Ken Marshall <ktm@rice.edu>
Cc: Hannu Krosing <hannuk@google.com>
Cc: Andreas Karlsson <andreas@proxel.se>
Cc: wenhui qiu <qiuwenhuifx@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Andres Freund <andres@anarazel.de>
Cc: Jelte Fennema-Nio <postgres@jeltef.nl>
Cc: Japin Li <japinli@hotmail.com>
Cc: Fujii Masao <masao.fujii@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Cc: John Naylor <johncnaylorls@gmail.com>
Subject: Re: WAL compression setting after PostgreSQL LZ4 default change
Date: Sun, 9 Aug 2026 19:25:26 +0200
Message-ID: <ani4BpccmFfbO9dq@msg.df7cb.de> (raw)
In-Reply-To: <9444bb52-136d-46e1-9989-ab514f127dc1@vondra.me>
References: <3ebe2c65-7fe5-49cb-ad49-84c1d0cf567b@vondra.me>
<CAMT0RQS_d-29QS50SYH=u15tPWrnb45ahJwi+D-5Yo6phO4mTw@mail.gmail.com>
<anSfQumImev8kDKI@customer.dllstxx1.isp.starlink.com>
<da2389df-05a0-4ba7-8284-4344d31b5882@vondra.me>
<1a39cbd6-6528-4f04-8d19-54e3790f006a@vondra.me>
<A0D6CED4-F9FB-4A96-A433-E1C3B3CE501E@yandex-team.ru>
<438ce1b2-54d5-4730-99aa-47b9b8f97a19@vondra.me>
<18d632e6-6fa9-42fc-9dda-bad166374aa5@vondra.me>
<anZbVWCy-pOqWboY@paquier.xyz>
<9444bb52-136d-46e1-9989-ab514f127dc1@vondra.me>
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
view thread (44+ messages) latest in thread
Message-ID: <ani4BpccmFfbO9dq@msg.df7cb.de>
Permalink: ../ani4BpccmFfbO9dq@msg.df7cb.de/
Also on: postgresql.org/message-id/ani4BpccmFfbO9dq@msg.df7cb.de
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: myon@debian.org, tomas@vondra.me, michael@paquier.xyz, x4mmm@yandex-team.ru, ktm@rice.edu, hannuk@google.com, andreas@proxel.se, qiuwenhuifx@gmail.com, laurenz.albe@cybertec.at, andres@anarazel.de, postgres@jeltef.nl, japinli@hotmail.com, masao.fujii@gmail.com, johncnaylorls@gmail.com
Subject: Re: WAL compression setting after PostgreSQL LZ4 default change
In-Reply-To: <ani4BpccmFfbO9dq@msg.df7cb.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox