Radix tree memory structure for vacuum
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.
VACUUM and Maintenance
Description
The internal structure for vacuum now uses a radix tree structure, which reduces the amount of memory required for the vacuum process. Additionally, vacuum is no longer limited to 1GB of memory even when maintenance_work_mem or autovacuum_work_mem are set to higher values.
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Recorded legacy identifiers: 419
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "radix-tree-memory-structure-for-vacuum",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "Radix tree memory structure for vacuum",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "Radix tree memory structure for vacuum",
"NameLocale": "en",
"GroupKey": "vacuum-and-maintenance",
"GroupName": "VACUUM and Maintenance",
"GroupLocale": "en",
"Ordinal": 5,
"GroupOrder": 16,
"Facts": {
"feature": {
"description": "The internal structure for vacuum now uses a radix tree structure, which reduces the amount of memory required for the vacuum process. Additionally, vacuum is no longer limited to 1GB of memory even when `maintenance_work_mem` or `autovacuum_work_mem` are set to higher values.",
"name": "Radix tree memory structure for vacuum",
"versions": {
"17": "Yes"
}
},
"group": "VACUUM and Maintenance",
"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": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "16",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "17",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "17",
"Supported": true,
"Original": "Yes"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "17",
"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": "Radix tree memory structure for vacuum",
"BodyHTML": "\u003cp\u003eThe internal structure for vacuum now uses a radix tree structure, which reduces the amount of memory required for the vacuum process. Additionally, vacuum is no longer limited to 1GB of memory even when \u003ccode\u003emaintenance_work_mem\u003c/code\u003e or \u003ccode\u003eautovacuum_work_mem\u003c/code\u003e are set to higher values.\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "0fd95103eba43a8da338b206b274384c780dd43c1c51e94bacf7f01e18f773ad",
"Payload": {
"description": "The internal structure for vacuum now uses a radix tree structure, which reduces the amount of memory required for the vacuum process. Additionally, vacuum is no longer limited to 1GB of memory even when `maintenance_work_mem` or `autovacuum_work_mem` are set to higher values.",
"name": "Radix tree memory structure for vacuum",
"versions": {
"17": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "VACUUM 的基数树内存结构",
"BodyHTML": "\u003cp\u003evacuum 的内部数据结构现在使用基数树，可显著降低内存占用，并支持使用超过 1GB 的内存。\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "9355628c0f856e779e3a5d5cb164bc36c34fffbfc5a8817dc5db55a48327921a",
"Payload": {
"description": "vacuum 的内部数据结构现在使用基数树，可显著降低内存占用，并支持使用超过 1GB 的内存。",
"name": "VACUUM 的基数树内存结构"
}
}
],
"GroupTitles": {
"en": "VACUUM and Maintenance",
"zh-Hans": "VACUUM 与维护"
},
"LegacyIDs": [
"419"
]
}