agora inbox for pgsql-hackers@postgresql.org
help / color / mirror / Atom feedFrom: Christoph Berg <myon@debian.org>
To: Tomas Vondra <tomas@vondra.me>
Cc: Andrey Borodin <x4mmm@yandex-team.ru>
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: Michael Paquier <michael@paquier.xyz>
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: Sat, 1 Aug 2026 00:50:45 +0200
Message-ID: <am0mxQtAsnwINgG7@msg.df7cb.de> (raw)
In-Reply-To: <6d594ed0-5705-4026-a30a-2c36a07a970d@vondra.me>
References: <50d60598-3fbf-4344-8b07-bf02114f7fd0@vondra.me>
<gf7azery3i6en6pljduxgxb2edikhbrmnvl7tkrt2wryezrrye@b4a3yo37d7pl>
<1314f5843859d5f83d5eb0a47b15d9291567cf40.camel@cybertec.at>
<CAGjGUA+ERbxcGzfiKDT2LpqU095E5=E2BvqCWXMTKgm-jns14Q@mail.gmail.com>
<amyWkBMR4hKVUZFv@msg.df7cb.de>
<e160948f-c272-4afb-8109-d82b06e52d11@vondra.me>
<amyexT2WCaoCBc7G@msg.df7cb.de>
<856ABCB3-1D3A-4E1D-B694-C258E95CA1AC@yandex-team.ru>
<amzEUaGtr8JsMVtR@msg.df7cb.de>
<6d594ed0-5705-4026-a30a-2c36a07a970d@vondra.me>
Re: Tomas Vondra
> Thanks. FWIW I've brought this up with the RMT, and there seem to be no
> objections to getting this done for PG19. Unless someone objects in the
> next couple days, I'll get it committed.
Thanks!
> 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.
Yes, lz4 makes sense to me now. zstd is the "can I tune it harder" pick.
Christoph
view thread (51+ messages) latest in thread
Message-ID: <am0mxQtAsnwINgG7@msg.df7cb.de>
Permalink: ../am0mxQtAsnwINgG7@msg.df7cb.de/
Also on: postgresql.org/message-id/am0mxQtAsnwINgG7@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, x4mmm@yandex-team.ru, qiuwenhuifx@gmail.com, laurenz.albe@cybertec.at, andres@anarazel.de, postgres@jeltef.nl, michael@paquier.xyz, japinli@hotmail.com, masao.fujii@gmail.com, johncnaylorls@gmail.com
Subject: Re: WAL compression setting after PostgreSQL LZ4 default change
In-Reply-To: <am0mxQtAsnwINgG7@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