{"capability":{"Key":"336","SourceKind":"legacy","SourceDatabase":"center","SourceTable":"featurematrix_feature","SourceKey":"336","SourceHash":"aa48af120863672a1b9a4bc459a27f663558b36a03bfefdbd43802cd7a8b2b98","Name":"基于磁盘的哈希聚合","NameLocale":"zh-Hans","GroupKey":"1","GroupName":"性能","GroupLocale":"zh-Hans","Ordinal":0,"GroupOrder":10,"Facts":{"featuredescription":"查询规划器现在可以在预计聚合将超过工作内存时考虑使用哈希聚合。\n\n这可以通过两个配置参数进行控制：\n\n- [enable_hashagg](https://www.postgresql.org/docs/13/runtime-config-query.html#GUC-ENABLE-HASHAGG)\n- [hash_mem_multiplier](https://www.postgresql.org/docs/13/runtime-config-resource.html#GUC-HASH-MEM-MULTIPLIER)","featurename":"基于磁盘的哈希聚合","group_id":1,"id":336,"v10":0,"v11":0,"v12":0,"v13":1,"v14":0,"v15":0,"v16":0,"v17":0,"v18":0,"v74":0,"v80":0,"v81":0,"v82":0,"v83":0,"v84":0,"v90":0,"v91":0,"v92":0,"v93":0,"v94":0,"v95":0,"v96":0},"Cells":[{"Version":"10","State":"no","EvidenceKind":"legacy-database:v10","TransitionVersion":"","Supported":false,"Original":0},{"Version":"11","State":"no","EvidenceKind":"legacy-database:v11","TransitionVersion":"","Supported":false,"Original":0},{"Version":"12","State":"no","EvidenceKind":"legacy-database:v12","TransitionVersion":"","Supported":false,"Original":0},{"Version":"13","State":"yes","EvidenceKind":"legacy-database:v13","TransitionVersion":"","Supported":true,"Original":1},{"Version":"14","State":"no","EvidenceKind":"legacy-database:v14","TransitionVersion":"","Supported":false,"Original":0},{"Version":"15","State":"no","EvidenceKind":"legacy-database:v15","TransitionVersion":"","Supported":false,"Original":0},{"Version":"16","State":"no","EvidenceKind":"legacy-database:v16","TransitionVersion":"","Supported":false,"Original":0},{"Version":"17","State":"no","EvidenceKind":"legacy-database:v17","TransitionVersion":"","Supported":false,"Original":0},{"Version":"18","State":"no","EvidenceKind":"legacy-database:v18","TransitionVersion":"","Supported":false,"Original":0},{"Version":"7.4","State":"no","EvidenceKind":"legacy-database:v74","TransitionVersion":"","Supported":false,"Original":0},{"Version":"8.0","State":"no","EvidenceKind":"legacy-database:v80","TransitionVersion":"","Supported":false,"Original":0},{"Version":"8.1","State":"no","EvidenceKind":"legacy-database:v81","TransitionVersion":"","Supported":false,"Original":0},{"Version":"8.2","State":"no","EvidenceKind":"legacy-database:v82","TransitionVersion":"","Supported":false,"Original":0},{"Version":"8.3","State":"no","EvidenceKind":"legacy-database:v83","TransitionVersion":"","Supported":false,"Original":0},{"Version":"8.4","State":"no","EvidenceKind":"legacy-database:v84","TransitionVersion":"","Supported":false,"Original":0},{"Version":"9.0","State":"no","EvidenceKind":"legacy-database:v90","TransitionVersion":"","Supported":false,"Original":0},{"Version":"9.1","State":"no","EvidenceKind":"legacy-database:v91","TransitionVersion":"","Supported":false,"Original":0},{"Version":"9.2","State":"no","EvidenceKind":"legacy-database:v92","TransitionVersion":"","Supported":false,"Original":0},{"Version":"9.3","State":"no","EvidenceKind":"legacy-database:v93","TransitionVersion":"","Supported":false,"Original":0},{"Version":"9.4","State":"no","EvidenceKind":"legacy-database:v94","TransitionVersion":"","Supported":false,"Original":0},{"Version":"9.5","State":"no","EvidenceKind":"legacy-database:v95","TransitionVersion":"","Supported":false,"Original":0},{"Version":"9.6","State":"no","EvidenceKind":"legacy-database:v96","TransitionVersion":"","Supported":false,"Original":0}],"Texts":[{"Locale":"zh-Hans","Title":"基于磁盘的哈希聚合","BodyHTML":"\u003cp\u003e查询规划器现在可以在预计聚合将超过工作内存时考虑使用哈希聚合。\u003c/p\u003e\n\u003cp\u003e这可以通过两个配置参数进行控制：\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003e\u003ca href=\"https://www.postgresql.org/docs/13/runtime-config-query.html#GUC-ENABLE-HASHAGG\" rel=\"nofollow\"\u003eenable_hashagg\u003c/a\u003e\u003c/li\u003e\n\u003cli\u003e\u003ca href=\"https://www.postgresql.org/docs/13/runtime-config-resource.html#GUC-HASH-MEM-MULTIPLIER\" rel=\"nofollow\"\u003ehash_mem_multiplier\u003c/a\u003e\u003c/li\u003e\n\u003c/ul\u003e\n","SourceHash":"aa48af120863672a1b9a4bc459a27f663558b36a03bfefdbd43802cd7a8b2b98","ContentHash":"2b062274d4f01772909acc01d25bcc16c2c9670bb7a46117832d9a3f0c1d4ac3","Payload":{"description":"查询规划器现在可以在预计聚合将超过工作内存时考虑使用哈希聚合。\n\n这可以通过两个配置参数进行控制：\n\n- [enable_hashagg](https://www.postgresql.org/docs/13/runtime-config-query.html#GUC-ENABLE-HASHAGG)\n- [hash_mem_multiplier](https://www.postgresql.org/docs/13/runtime-config-resource.html#GUC-HASH-MEM-MULTIPLIER)","name":"基于磁盘的哈希聚合"}}],"GroupTitles":{"zh-Hans":"性能"},"RelatedKey":"hash-aggregation-can-use-disk"},"observed":true,"selected_cell":{"Version":"18","State":"no","EvidenceKind":"legacy-database:v18","TransitionVersion":"","Supported":false,"Original":0},"selected_version":"18"}