wal_compression

A server parameter determining whether WAL should be compressed

wal_compression is a configuration parameter determining whether full page images should be compressed.

wal_compression was added in PostgreSQL 9.5.

Default value

The default value for wal_compression is: off.

Usage

In PostgreSQL 14 and earlier, wal_compression was a boolean setting, with "on" enabling PostgreSQL's built-in compression method.

From PostgreSQL 15, following values are permitted, depending on how PostgreSQL was compiled:

  • off
  • pglz (alias: on)
  • lz4 (if PostgreSQL was compiled with --with-lz4)
  • zstd (if PostgreSQL was compiled with --with-zstd)

Change history

Categories

GUC configuration item, WAL

See also

wal_log_hints, wal_recycle