Type: | bool |
Default: | off |
Context: | user |
Restart: | false |
Since: | 11 |
Enables or disables the query planner's use of partitionwise join, which allows a join between partitioned tables to be performed by joining the matching partitions. Partitionwise join currently applies only when the join conditions include all the partition keys, which must be of the same data type and have one-to-one matching sets of child partitions. Because partitionwise join planning can use significantly more CPU time and memory during planning, the default is off
.
On StackOverflow
On pgsql-hackers
- Re: Missing MaterialPath support in reparameterize_path_by_child
- Re: Oversight in reparameterize_path_by_child leading to executor crash
- Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning
- Missing MaterialPath support in reparameterize_path_by_child
- RE: Partial aggregates pushdown