To enable the WAL compression for streaming replication feature, set the streaming_wal_compression parameter.
Parameter Name | Description |
---|---|
streaming_wal_compression | Specifies that you want to send a compressed WAL by streaming replication. -1: Compress at zlib's default compression level 0: Uncompressed 1-9: Compress at specified compression level, 9 is high compression Default is uncompressed. |
Example
Here is an example postgresql.conf configuration:
streaming_wal_compression = 1
Note
Using zEDC for compression / decompression speeds up compression / decompression.
Because compression is performed on the primary server, if you want to compress using zEDC, you set zEDC on primary server.
Because decompression is performed on the standby server, if you want to decompress using zEDC, you set zEDC on standby server.
Refer to the IBM documentation for information on configuring the zEDC.