{"capability":{"Key":"improved-performance-for-sorts-exceeding-working-memory","SourceKind":"yaml","SourceDatabase":"center","SourceTable":"featurematrix.yaml","SourceKey":"Improved performance for sorts exceeding working memory","SourceHash":"1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd","Name":"Improved performance for sorts exceeding working memory","NameLocale":"en","GroupKey":"performance","GroupName":"Performance","GroupLocale":"en","Ordinal":19,"GroupOrder":5,"Facts":{"feature":{"description":"Sorts for data sets that exceed [`work_mem`](https://www.postgresql.org/docs/current/runtime-config-resource.html#GUC-WORK-MEM) now use a batch sorting algorithm that uses more output streams and improves performance.","name":"Improved performance for sorts exceeding working memory","versions":{"15":"Yes"}},"group":"Performance","versions":{"max":18,"min":8.1}},"Cells":[{"Version":"10","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"11","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"12","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"13","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"14","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"15","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"15","Supported":true,"Original":"Yes"},{"Version":"16","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"15","Supported":true,"Original":"Yes"},{"Version":"17","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"15","Supported":true,"Original":"Yes"},{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"15","Supported":true,"Original":"Yes"},{"Version":"8.1","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"8.2","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"8.3","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"8.4","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.0","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.1","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.2","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.3","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.4","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.5","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.6","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"}],"Texts":[{"Locale":"en","Title":"Improved performance for sorts exceeding working memory","BodyHTML":"\u003cp\u003eSorts for data sets that exceed \u003ca href=\"https://www.postgresql.org/docs/current/runtime-config-resource.html#GUC-WORK-MEM\" rel=\"nofollow\"\u003e\u003ccode\u003ework_mem\u003c/code\u003e\u003c/a\u003e now use a batch sorting algorithm that uses more output streams and improves performance.\u003c/p\u003e\n","SourceHash":"1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd","ContentHash":"9b3006939d5485e479808b67db3668ff4accb469b5b07871c7f923af4d05f087","Payload":{"description":"Sorts for data sets that exceed [`work_mem`](https://www.postgresql.org/docs/current/runtime-config-resource.html#GUC-WORK-MEM) now use a batch sorting algorithm that uses more output streams and improves performance.","name":"Improved performance for sorts exceeding working memory","versions":{"15":"Yes"}}},{"Locale":"zh-Hans","Title":"超出工作内存的排序性能提升","BodyHTML":"\u003cp\u003e当排序数据超出 \u003ccode\u003ework_mem\u003c/code\u003e 时，排序现在会使用批处理算法，从而提升性能。\u003c/p\u003e\n","SourceHash":"071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50","ContentHash":"bdce5f4f06b447b12f6ba14ff6223c4773d66aad72f853a8715967762f7e97ee","Payload":{"description":"当排序数据超出 `work_mem` 时，排序现在会使用批处理算法，从而提升性能。","name":"超出工作内存的排序性能提升"}}],"GroupTitles":{"en":"Performance","zh-Hans":"性能"},"LegacyIDs":["368"]},"observed":true,"selected_cell":{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"15","Supported":true,"Original":"Yes"},"selected_version":"18"}