| 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
- any issue with enable_partitionwise_join at instance level
- Large COUNT DISTINCT performs slowly in postgresql
- Geoserver WFS + PostgreSQL with large table impossibly slow
- Why does "explain analyzing" this query fnish fast (showing a parallel plan), while running the actual query without "explain analyze" doesn't?
- PostgreSQL 13 sometimes works but sometimes huge execution time
On pgsql-hackers
- Re: Asymmetric partition-wise JOIN
- Re: Why OR-clauses not getting copied into baserestrictinfo of another table whose columns are in the same EquivalenceClass?
- Re: Asynchronous Append on postgres_fdw nodes.
- Re: suggest to rename enable_incrementalsort
- Combination of geqo and enable_partitionwise_join leads to crashes in the regression tests