logical_decoding_work_mem
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.
英文手册覆盖始于 PostgreSQL 7.4. 来源历史与运行验证各自保留独立版本边界。
当前阅读 PG 18·选择有来源记录的版本
此版本暂无所选语言的定义，以下显示原始英文内容。
- boot val
- 65536
- category
- Resource Usage / Memory
- context
- user
- documented
- true
- enumvals
- 未知
- 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
版本定义 PG 18
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.
比较版本
来源引用
定义来源
center · PostgreSQL 18 · english-manuals:70deb7d3470eb5421bc08f19b87c0512da9bea98f186b6b585a75f9bf1ac8629
正文语言: en · english-manuals:70deb7d3470eb5421bc08f19b87c0512da9bea98f186b6b585a75f9bf1ac8629