| 类型: | bool |
| 默认: | off |
| 上下文: | user |
| 重新开始: | false |
| 以来: | 11 |
允许或者禁止查询规划器使用面向分区的连接，这使得分区表之间的连接以连接匹配的分区的方式来执行。面向分区的连接当前只适用于连接条件包括所有分区键的情况，连接条件必须是相同的数据类型并且子分区集合要完全匹配。由于面向分区的连接规划在规划期间会使用可观的CPU时间和内存，所以默认值为off。
在 StackOverflow
- any issue with enable_partitionwise_join at instance level
- How to do a major version upgrade for Aurora Postgres in CloudFormation with custom Parameter Groups?
- Large COUNT DISTINCT performs slowly in postgresql
- Geoserver WFS + PostgreSQL with large table impossibly slow
- Java Hibernate insert hypertable in timescaledb is very slow
在 pgsql-hackers
- Re: Why OR-clauses not getting copied into baserestrictinfo of another table whose columns are in the same EquivalenceClass?
- Combination of geqo and enable_partitionwise_join leads to crashes in the regression tests
- Re: Combination of geqo and enable_partitionwise_join leads to crashes in the regression tests
- Re: Hybrid Hash/Nested Loop joins and caching results from subplans
- pg13dev: explain partial, parallel hashagg, and memory use