enable_partitionwise_aggregate
Enables or disables the query planner's use of partitionwise grouping or aggregation, which allows grouping or aggregation on a partitioned tables 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. Because partitionwise grouping or aggregation can use significantly more CPU time and memory during planning, the default is off
.
Comments
Type: | bool |
Default: | off |
Context: | user |
Restart: | false |
Since: | 11 |
On pgsql-hackers
- Re: Server crashed with TRAP: FailedAssertion("!(parallel_workers > 0)" when partitionwise_aggregate true.
- Server crashed with TRAP: FailedAssertion("!(parallel_workers > 0)" when partitionwise_aggregate true.
- Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0
- Re: [HACKERS] Partition-wise aggregation/grouping