| 类型: | bool |
| 默认: | off |
| 上下文: | user |
| 重新开始: | false |
| 以来: | 11 |
允许或者禁止查询规划器使用面向分区的分组或聚集,这使得在分区表上的分组或聚集可以在每个分区上分别执行。如果GROUP BY子句不包括分区键,只有部分聚集能够以基于每个分区的方式执行,并且finalization必须最后执行。由于面向分区的分组或聚集在规划期间会使用可观的CPU时间和内存,所以默认值为off。
在 StackOverflow
- 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
- Why does "explain analyzing" this query fnish fast (showing a parallel plan), while running the actual query without "explain analyze" doesn't?
