> 16 июня 2021 г., в 13:49, Heikki Linnakangas <hlinn...@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 the compression, 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
- Re: Different compression methods for FPI Michael Paquier
- Re: Different compression methods for FPI Justin Pryzby
- Re: Different compression methods for FPI Heikki Linnakangas
- Re: Different compression methods for FPI Michael Paquier
- Re: Different compression methods for FPI Peter Eisentraut
- Re: Different compression methods for FPI Justin Pryzby
- Re: Different compression methods for FPI Michael Paquier
- Re: Different compression methods for FPI Michael Paquier
- Re: Different compression methods for FPI Andrey Borodin
- Re: Different compression methods for FPI Heikki Linnakangas
- Re: Different compression methods for FPI Andrey Borodin
- Re: Different compression methods for FPI Michael Paquier
- Re: Different compression methods for FPI Heikki Linnakangas
- Re: Different compression methods for FPI Michael Paquier
- Re: Different compression methods for FPI Michael Paquier
- Re: Different compression methods for FPI Michael Paquier
- Re: Different compression methods for FPI Andrey Borodin
- Re: Different compression methods for FPI Michael Paquier
- Re: Different compression methods for FPI Justin Pryzby
- Re: Different compression methods for FPI Michael Paquier
- Re: Different compression methods for FPI Michael Paquier