Re: WAL compression setting after PostgreSQL LZ4 default change

From: Christoph Berg <myon(at)debian(dot)org>
To: wenhui qiu <qiuwenhuifx(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Japin Li <japinli(at)hotmail(dot)com>, John Naylor <johncnaylorls(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>
Subject: Re: WAL compression setting after PostgreSQL LZ4 default change
Date: 2026-06-30 10:51:13
Message-ID: akOfoQCqMrXGx5UJ@msg.df7cb.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Re: wenhui qiu
> The recent PostgreSQL commit changes the default TOAST compression to lz4
> when LZ4 support is available, based on the rationale that LZ4 is generally
> more efficient than pglz in terms of CPU usage and compression ratio.Given
> that, should we also consider changing the default compression method used
> by wal_compression = on from pglz to lz4?

+1 from me. I would prefer this patch over the doc-only one that I
sent in the other thread.

This should go into PG19 so we don't have two different versions that
flip the default from pglz to lz4.

Christoph

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nazir Bilal Yavuz 2026-06-30 10:58:25 Re: Differential Code Coverage report for Postgres
Previous Message wenhui qiu 2026-06-30 10:25:09 WAL compression setting after PostgreSQL LZ4 default change