>According to the measurement result, the amount of WAL generated in
>"Multiple Blocks in one run" than that in "Single Block in one run".
>So ISTM that compression of multiple blocks at one run can improve
>the compression ratio. Am I missing something?

Sorry for using unclear terminology. WAL generated here means WAL that gets
generated in each run without compression.
So, the value WAL generated in the  above measurement is uncompressed WAL
generated to be specific.
uncompressed WAL = compressed WAL  + Bytes saved.

Here, the measurements are done for a constant amount of time rather than
fixed number of transactions. Hence amount of WAL generated does not
correspond to compression ratios of each algo. Hence have calculated bytes
saved in order to get accurate idea of the amount of compression in each
scenario and for various algorithms.

Compression ratio i.e Uncompressed WAL/compressed WAL in each of the above
scenarios are as follows:

Compression algo       Multiple Blocks in one run    Single Block in one run

LZ4                              1.21                                   1.27

Snappy                        1.19                                   1.25

pglz                             1.14                                   1.16

This shows compression ratios of both the scenarios Multiple blocks and
single block  are nearly same for this benchmark.

Thank you,

Rahila Syed

Reply via email to