Wiki / Configuration Parameters

Specifies the maximum amount of memory to be used by logical decoding, before some of the decoded changes are written to local disk. This limits the amount of memory used by logical streaming replication connections. It defaults to 64 megabytes (64MB). Since each replication connection only uses a single buffer of this size, and an installation normally doesn't have many such connections concurrently (as limited by max_wal_senders), it's safe to set this value significantly higher than work_mem, reducing the amount of decoded changes written to disk.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

boot val

65536

category

Resource Usage / Memory

context

user

documented

true

enumvals

Unknown

extra desc

This much memory can be used by each internal reorder buffer before spilling to disk.

lang

en

max val

2147483647

metadata version

18

min val

64

name

logical_decoding_work_mem

short desc

Sets the maximum memory to be used for logical decoding.

source

pg-settings-source-snapshot

unit

kB

vartype

integer