Top
Enterprise Postgres 17 SP1 Operation Guide

17.1.2 Enabling WAL Compression for Streaming Replication Fetature

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.