Reduced lock levels for ALTER TABLE commands
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.
Performance
Description
The following commands now have reduced lock levels for reduced lock contention:
VALIDATE CONSTRAINT
CLUSTER ON SET WITHOUT CLUSTER
ALTER COLUMN SET STATISTICS ALTER COLUMN SET () ALTER COLUMN RESET ()
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Recorded legacy identifiers: 258
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "reduced-lock-levels-for-alter-table-commands",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "Reduced lock levels for ALTER TABLE commands",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "Reduced lock levels for ALTER TABLE commands",
"NameLocale": "en",
"GroupKey": "performance",
"GroupName": "Performance",
"GroupLocale": "en",
"Ordinal": 42,
"GroupOrder": 5,
"Facts": {
"feature": {
"description": "The following commands now have reduced lock levels for reduced lock contention:\r\n\r\nVALIDATE CONSTRAINT\r\n\r\nCLUSTER ON\r\nSET WITHOUT CLUSTER\r\n\r\nALTER COLUMN SET STATISTICS\r\nALTER COLUMN SET ()\r\nALTER COLUMN RESET ()",
"name": "Reduced lock levels for ALTER TABLE commands",
"versions": {
"9.4": "Yes"
}
},
"group": "Performance",
"versions": {
"max": 18,
"min": 8.1
}
},
"Cells": [
{
"Version": "10",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "11",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "12",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "13",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "14",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "15",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "16",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "17",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"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": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.5",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.6",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
}
],
"Texts": [
{
"Locale": "en",
"Title": "Reduced lock levels for ALTER TABLE commands",
"BodyHTML": "\u003cp\u003eThe following commands now have reduced lock levels for reduced lock contention:\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": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "2ac3c0ba433c8227adde1d6623f4a31a3f42c11714a41ea06ce75eed5dbab72e",
"Payload": {
"description": "The following commands now have reduced lock levels for reduced lock contention:\r\n\r\nVALIDATE CONSTRAINT\r\n\r\nCLUSTER ON\r\nSET WITHOUT CLUSTER\r\n\r\nALTER COLUMN SET STATISTICS\r\nALTER COLUMN SET ()\r\nALTER COLUMN RESET ()",
"name": "Reduced lock levels for ALTER TABLE commands",
"versions": {
"9.4": "Yes"
}
}
},
{
"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": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"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": {
"en": "Performance",
"zh-Hans": "性能"
},
"LegacyIDs": [
"258"
]
}