缩写键
Recorded source states and original language descriptions. Missing version evidence stays unknown.
The source snapshot records transitions for PostgreSQL 8.1–18. The historical matrix records independent cells for 7.4–18. Neither records support for PostgreSQL 19 or 20; newer versions remain unknown. These source claims are distinct from runtime measurements.
No translation of this description is recorded. The original Chinese description is shown. The source label is retained in Chinese; no translated label is recorded.
性能
Description
缩写键优化可以大幅提升 PostgreSQL 中排序的性能，包括用于 CREATE INDEX 的排序。据报告，在某些情况下，文本列上的 CREATE INDEX 速度可以快整整一个数量级（3 倍是更典型的提升）。数值排序也支持此优化。
Selected version: PostgreSQL 18
No
Compare versions
Original documentation links
Related source snapshot entry · The original source supplies this relationship; each matrix retains its own states.
Complete source facts and provenance
legacy · center · bbddd780205a9dee2d776c7209a91c14ced5a657dcb3e6cd36a4fddd6097fb70
{
"Key": "279",
"SourceKind": "legacy",
"SourceDatabase": "center",
"SourceTable": "featurematrix_feature",
"SourceKey": "279",
"SourceHash": "bbddd780205a9dee2d776c7209a91c14ced5a657dcb3e6cd36a4fddd6097fb70",
"Name": "缩写键",
"NameLocale": "zh-Hans",
"GroupKey": "1",
"GroupName": "性能",
"GroupLocale": "zh-Hans",
"Ordinal": 0,
"GroupOrder": 10,
"Facts": {
"featuredescription": "缩写键优化可以大幅提升 PostgreSQL 中排序的性能，包括用于 CREATE INDEX 的排序。据报告，在某些情况下，文本列上的 CREATE INDEX 速度可以快整整一个数量级（3 倍是更典型的提升）。数值排序也支持此优化。",
"featurename": "缩写键",
"group_id": 1,
"id": 279,
"v10": 1,
"v11": 1,
"v12": 1,
"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": 1,
"v96": 1
},
"Cells": [
{
"Version": "10",
"State": "yes",
"EvidenceKind": "legacy-database:v10",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "11",
"State": "yes",
"EvidenceKind": "legacy-database:v11",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "12",
"State": "yes",
"EvidenceKind": "legacy-database:v12",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"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": "yes",
"EvidenceKind": "legacy-database:v95",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "9.6",
"State": "yes",
"EvidenceKind": "legacy-database:v96",
"TransitionVersion": "",
"Supported": true,
"Original": 1
}
],
"Texts": [
{
"Locale": "zh-Hans",
"Title": "缩写键",
"BodyHTML": "\u003cp\u003e缩写键优化可以大幅提升 PostgreSQL 中排序的性能，包括用于 CREATE INDEX 的排序。据报告，在某些情况下，文本列上的 CREATE INDEX 速度可以快整整一个数量级（3 倍是更典型的提升）。数值排序也支持此优化。\u003c/p\u003e\n",
"SourceHash": "bbddd780205a9dee2d776c7209a91c14ced5a657dcb3e6cd36a4fddd6097fb70",
"ContentHash": "7f56b187de7d578ac26b9ebb7b2b79af4ad7a8bbdb778869b70950da8df68eb1",
"Payload": {
"description": "缩写键优化可以大幅提升 PostgreSQL 中排序的性能，包括用于 CREATE INDEX 的排序。据报告，在某些情况下，文本列上的 CREATE INDEX 速度可以快整整一个数量级（3 倍是更典型的提升）。数值排序也支持此优化。",
"name": "缩写键"
}
}
],
"GroupTitles": {
"zh-Hans": "性能"
},
"RelatedKey": "abbreviated-keys"
}