Manage
CO.NF for your Blog
Configuration Snippet Parameter Snippet

wal_level

  1. Documentation
  2. Write-Ahead Log
  3. Settings
  4. wal_level
COPY SHARING LINK
Type: enum
Default: replica
Context: postmaster
Restart: true
Values: [minimal, replica, logical]
Set the level of information written to the WAL

wal_level determines how much information is written to the WAL. The default value is replica, which writes enough data to support WAL archiving and replication, including running read-only queries on a standby server. minimal removes all logging except the information required to recover from a crash or immediate shutdown. Finally, logical adds information necessary to support logical decoding. Each level includes the information logged at all lower levels. This parameter can only be set at server start.

In minimal level, no information is logged for permanent relations for the remainder of a transaction that creates or rewrites them. This can make operations much faster (see populate-pitr). Operations that initiate this optimization include:

  • ALTER ... SET TABLESPACE
  • CLUSTER
  • CREATE TABLE
  • REFRESH MATERIALIZED VIEW (without CONCURRENTLY)
  • REINDEX
  • TRUNCATE
But minimal WAL does not contain enough information to reconstruct the data from a base backup and the WAL logs, so replica or higher must be used to enable WAL archiving (archive_mode) and streaming replication.

In logical level, the same information is logged as with replica, plus information needed to allow extracting logical change sets from the WAL. Using a level of logical will increase the WAL volume, particularly if many tables are configured for REPLICA IDENTITY FULL and many UPDATE and DELETE statements are executed.

In releases prior to 9.6, this parameter also allowed the values archive and hot_standby. These are still accepted but mapped to replica.

Official docs

Search in source code

Recommendations

Level replica is required for binary replication, and level logical is required for logical replication. This is a setting because raising the level adds more writes to the WAL, so if you’re not doing replication or archiving at all, set it to minimal.
By annotated.conf

Comments