| 类型: | bool |
| 默认: | off |
| 上下文: | user |
| 重新开始: | false |
| 以来: | 11 |
允许或者禁止查询规划器使用面向分区的连接，这使得分区表之间的连接以连接匹配的分区的方式来执行。面向分区的连接当前只适用于连接条件包括所有分区键的情况，连接条件必须是相同的数据类型并且子分区集合要完全匹配。由于面向分区的连接规划在规划期间会使用可观的CPU时间和内存，所以默认值为off。
在 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
在 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