Re: Compression of bigger WAL records - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: Compression of bigger WAL records
Date
Msg-id 7F4307A0-0BFE-4B77-93B6-2FDD52F0586C@yandex-team.ru
Whole thread Raw
In response to Re: Compression of bigger WAL records  (Fujii Masao <masao.fujii@oss.nttdata.com>)
List pgsql-hackers

> On 31 Jan 2025, at 08:37, wenhui qiu <qiuwenhuifx@gmail.com> wrote:
>
> Hi Andery
>      I have a question ,If wal_compression_threshold is set to more than the block size of the wal log, then the FPI
isnot compressed, and if so, it might make sense to have a maximum value of this parameter that does not exceed the
blocksize of the wal log? 

Oops, looks like I missed your question. Sorry for so long delay.

User might want to compress only megabyte+ records, there's nothing wrong with it. WAL record itself is capped by 1Gb
(XLogRecordMaxSize),I do not see a reason to restrict wal_compression_threshold by lower value. 

PFA rebased version.


Best regards, Andrey Borodin.


Attachment

pgsql-hackers by date:

Previous
From: "Scott Mead"
Date:
Subject: Re: Disable parallel query by default
Next
From: Álvaro Herrera
Date:
Subject: Re: pg_dump does not dump domain not-null constraint's comments