parallel_leader_participation
Allows the leader process to execute the query plan under Gather and Gather Merge nodes instead of waiting for worker processes. The default is on. Setting this value to off reduces the likelihood that workers will become blocked because the leader is not reading tuples fast enough, but requires the leader process to wait for worker processes to start up before the first tuples can be produced. The degree to which the leader can help or hinder performance depends on the plan type, number of workers and query duration.
英文手册覆盖始于 PostgreSQL 7.4. 来源历史与运行验证各自保留独立版本边界。
当前阅读 PG 18·选择有来源记录的版本
此版本暂无所选语言的定义，以下显示原始英文内容。
- boot val
- on
- category
- Resource Usage / Worker Processes
- context
- user
- documented
- true
- enumvals
- 未知
- extra desc
- Should gather nodes also run subplans or just gather tuples?
- lang
- en
- max val
- 未知
- metadata version
- 18
- min val
- 未知
- name
- parallel_leader_participation
- short desc
- Controls whether Gather and Gather Merge also run subplans.
- source
- pg-settings-source-snapshot
- unit
- 未知
- vartype
- bool
版本定义 PG 18
Allows the leader process to execute the query plan under Gather and Gather Merge nodes instead of waiting for worker processes. The default is on. Setting this value to off reduces the likelihood that workers will become blocked because the leader is not reading tuples fast enough, but requires the leader process to wait for worker processes to start up before the first tuples can be produced. The degree to which the leader can help or hinder performance depends on the plan type, number of workers and query duration.
比较版本
来源引用
定义来源
center · PostgreSQL 18 · english-manuals:538511fdf8e77b3139233af18c5904719e609b635aabbfbedc510edb0b3252a9
正文语言: en · english-manuals:538511fdf8e77b3139233af18c5904719e609b635aabbfbedc510edb0b3252a9