{"capability":{"Key":"improved-window-function-performance","SourceKind":"yaml","SourceDatabase":"center","SourceTable":"featurematrix.yaml","SourceKey":"Improved window function performance","SourceHash":"1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd","Name":"Improved window function performance","NameLocale":"en","GroupKey":"performance","GroupName":"Performance","GroupLocale":"en","Ordinal":20,"GroupOrder":5,"Facts":{"feature":{"description":"Performance optimizations for executing [window functions](https://www.postgresql.org/docs/current/functions-window.html) `row_number()`, `rank()`, and `count()`.","name":"Improved window function performance","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 window function performance","BodyHTML":"\u003cp\u003ePerformance optimizations for executing \u003ca href=\"https://www.postgresql.org/docs/current/functions-window.html\" rel=\"nofollow\"\u003ewindow functions\u003c/a\u003e \u003ccode\u003erow_number()\u003c/code\u003e, \u003ccode\u003erank()\u003c/code\u003e, and \u003ccode\u003ecount()\u003c/code\u003e.\u003c/p\u003e\n","SourceHash":"1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd","ContentHash":"d85537f9a0c0c9458561c6d42295199aa5a713c4b638af5cbf3ac871a68fa4b3","Payload":{"description":"Performance optimizations for executing [window functions](https://www.postgresql.org/docs/current/functions-window.html) `row_number()`, `rank()`, and `count()`.","name":"Improved window function performance","versions":{"15":"Yes"}}},{"Locale":"zh-Hans","Title":"窗口函数性能提升","BodyHTML":"\u003cp\u003e对 \u003ccode\u003erow_number()\u003c/code\u003e、\u003ccode\u003erank()\u003c/code\u003e 和 \u003ccode\u003ecount()\u003c/code\u003e 等窗口函数的执行进行了优化。\u003c/p\u003e\n","SourceHash":"071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50","ContentHash":"2720b1352e519ae7c55915807723964103ff1265181bdd38dab69773cdc610a0","Payload":{"description":"对 `row_number()`、`rank()` 和 `count()` 等窗口函数的执行进行了优化。","name":"窗口函数性能提升"}}],"GroupTitles":{"en":"Performance","zh-Hans":"性能"},"LegacyIDs":["370"]},"observed":true,"selected_cell":{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"15","Supported":true,"Original":"Yes"},"selected_version":"18"}