Re: Compression of bigger WAL records

Поиск
Список
Период
Сортировка
От Andrey Borodin
Тема Re: Compression of bigger WAL records
Дата
Msg-id 7F4307A0-0BFE-4B77-93B6-2FDD52F0586C@yandex-team.ru
обсуждение исходный текст
Ответ на Re: Compression of bigger WAL records  (Fujii Masao <masao.fujii@oss.nttdata.com>)
Список 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.


Вложения

В списке pgsql-hackers по дате отправления: