Wiki / 配置参数

Enables or disables the query planner's use of partitionwise grouping or aggregation, which allows grouping or aggregation on partitioned tables to be performed separately for each partition. If the GROUP BY clause does not include the partition keys, only partial aggregation can be performed on a per-partition basis, and finalization must be performed later. With this setting enabled, the number of nodes whose memory usage is restricted by work_mem appearing in the final plan can increase linearly according to the number of partitions being scanned. This can result in a large increase in overall memory consumption during the execution of the query. Query planning also becomes significantly more expensive in terms of memory and CPU. The default value is off.

英文手册覆盖始于 PostgreSQL 7.4. 来源历史与运行验证各自保留独立版本边界。

此版本暂无所选语言的定义，以下显示原始英文内容。

boot val

off

category

Query Tuning / Planner Method Configuration

context

user

documented

true

enumvals

未知

extra desc

未知

lang

en

max val

未知

metadata version

18

min val

未知

name

enable_partitionwise_aggregate

short desc

Enables partitionwise aggregation and grouping.

source

pg-settings-source-snapshot

unit

未知

vartype

bool