ALTER TABLE 命令的锁定级别降低
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
以下命令现在具有更低的锁定级别以减少锁竞争：
VALIDATE CONSTRAINT
CLUSTER ON SET WITHOUT CLUSTER
ALTER COLUMN SET STATISTICS ALTER COLUMN SET () ALTER COLUMN RESET ()
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 · a2d7b2bda0547c4056800770017cdd187e1c7eae6224b0a2a18a2c7457c88f22
{
"Key": "258",
"SourceKind": "legacy",
"SourceDatabase": "center",
"SourceTable": "featurematrix_feature",
"SourceKey": "258",
"SourceHash": "a2d7b2bda0547c4056800770017cdd187e1c7eae6224b0a2a18a2c7457c88f22",
"Name": "ALTER TABLE 命令的锁定级别降低",
"NameLocale": "zh-Hans",
"GroupKey": "1",
"GroupName": "性能",
"GroupLocale": "zh-Hans",
"Ordinal": 0,
"GroupOrder": 10,
"Facts": {
"featuredescription": "以下命令现在具有更低的锁定级别以减少锁竞争：\n\nVALIDATE CONSTRAINT\n\nCLUSTER ON\nSET WITHOUT CLUSTER\n\nALTER COLUMN SET STATISTICS\nALTER COLUMN SET ()\nALTER COLUMN RESET ()",
"featurename": "ALTER TABLE 命令的锁定级别降低",
"group_id": 1,
"id": 258,
"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": 1,
"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": "yes",
"EvidenceKind": "legacy-database:v94",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"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": "ALTER TABLE 命令的锁定级别降低",
"BodyHTML": "\u003cp\u003e以下命令现在具有更低的锁定级别以减少锁竞争：\u003c/p\u003e\n\u003cp\u003eVALIDATE CONSTRAINT\u003c/p\u003e\n\u003cp\u003eCLUSTER ON\nSET WITHOUT CLUSTER\u003c/p\u003e\n\u003cp\u003eALTER COLUMN SET STATISTICS\nALTER COLUMN SET ()\nALTER COLUMN RESET ()\u003c/p\u003e\n",
"SourceHash": "a2d7b2bda0547c4056800770017cdd187e1c7eae6224b0a2a18a2c7457c88f22",
"ContentHash": "daeb107dfaeddbc2b779f9b8dd3da94e19443898dcd48aee27c684a7f911f50c",
"Payload": {
"description": "以下命令现在具有更低的锁定级别以减少锁竞争：\n\nVALIDATE CONSTRAINT\n\nCLUSTER ON\nSET WITHOUT CLUSTER\n\nALTER COLUMN SET STATISTICS\nALTER COLUMN SET ()\nALTER COLUMN RESET ()",
"name": "ALTER TABLE 命令的锁定级别降低"
}
}
],
"GroupTitles": {
"zh-Hans": "性能"
},
"RelatedKey": "reduced-lock-levels-for-alter-table-commands"
}