Re: Different compression methods for FPI - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: Different compression methods for FPI
Date
Msg-id 956D54DE-3347-46A8-BF00-AF585526FDF2@yandex-team.ru
Whole thread Raw
In response to Re: Different compression methods for FPI  (Heikki Linnakangas <hlinnaka@iki.fi>)
List pgsql-hackers

> 16 июня 2021 г., в 13:49, Heikki Linnakangas <hlinnaka@iki.fi> написал(а):
>
> Hmm, do we currently compress each block in a WAL record separately, for records that contain multiple full-page
images?That could make a big difference e.g. for GiST index build that WAL-logs 32 pages in each record. If it helps
thecompression, we should probably start WAL-logging b-tree index build in larger batches, too. 

Here's PoC for this [0]. But benchmark results are HW-dependent.

Best regards, Andrey Borodin.

https://www.postgresql.org/message-id/flat/41822E78-48EE-41AE-A89B-3CB76FF53980%40yandex-team.ru


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Different compression methods for FPI
Next
From: Amit Kapila
Date:
Subject: Re: Skipping logical replication transactions on subscriber side