enable_partitionwise_aggregate
Enables partitionwise aggregation and grouping
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.
| Type: | bool |
| Default: | off |
| Context: | user |
| Restart: | false |
| Since: | 11 |