↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Versions

Visibility Map for Vacuuming

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

This reduces the overhead of vacuuming as the visibility map tracks only the pages that need to be vacuumed.

Selected version: PostgreSQL 18

Yes

20191817161514131211109.69.59.49.39.29.19.08.48.38.28.18.07.4
UnknownUnknownYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesNoNoNoUnknownUnknown

Compare versions

Original documentation links

Recorded legacy identifiers: 158

Complete source facts and provenance

yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd

{
  "Key": "visibility-map-for-vacuuming",
  "SourceKind": "yaml",
  "SourceDatabase": "center",
  "SourceTable": "featurematrix.yaml",
  "SourceKey": "Visibility Map for Vacuuming",
  "SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
  "Name": "Visibility Map for Vacuuming",
  "NameLocale": "en",
  "GroupKey": "vacuum-and-maintenance",
  "GroupName": "VACUUM and Maintenance",
  "GroupLocale": "en",
  "Ordinal": 7,
  "GroupOrder": 16,
  "Facts": {
    "feature": {
      "description": "This reduces the overhead of vacuuming as the visibility map tracks only the pages that need to be vacuumed.",
      "name": "Visibility Map for Vacuuming",
      "versions": {
        "8.4": "Yes"
      }
    },
    "group": "VACUUM and Maintenance",
    "versions": {
      "max": 18,
      "min": 8.1
    }
  },
  "Cells": [
    {
      "Version": "10",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.4",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "11",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.4",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "12",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.4",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "13",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.4",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "14",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.4",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "15",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.4",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "16",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.4",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "17",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.4",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "18",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.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": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.4",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.0",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.4",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.1",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.4",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.2",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.4",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.3",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.4",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.4",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.4",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.5",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.4",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.6",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.4",
      "Supported": true,
      "Original": "Yes"
    }
  ],
  "Texts": [
    {
      "Locale": "en",
      "Title": "Visibility Map for Vacuuming",
      "BodyHTML": "\u003cp\u003eThis reduces the overhead of vacuuming as the visibility map tracks only the pages that need to be vacuumed.\u003c/p\u003e\n",
      "SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
      "ContentHash": "70823117c73dbbe05c556143b0752f8a9bf2603db7e88074631f7aa4efaa59b1",
      "Payload": {
        "description": "This reduces the overhead of vacuuming as the visibility map tracks only the pages that need to be vacuumed.",
        "name": "Visibility Map for Vacuuming",
        "versions": {
          "8.4": "Yes"
        }
      }
    },
    {
      "Locale": "zh-Hans",
      "Title": "清理使用的可见性映射",
      "BodyHTML": "\u003cp\u003e可见性映射记录页面的全可见状态,使 VACUUM 能够跳过无需扫描的页面,从而减少清理开销。\u003c/p\u003e\n",
      "SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
      "ContentHash": "3a53ab6f1b391ca3c4c27c26a13ec3fa003028debec691c362f9b9f264dd6704",
      "Payload": {
        "description": "可见性映射记录页面的全可见状态,使 VACUUM 能够跳过无需扫描的页面,从而减少清理开销。",
        "name": "清理使用的可见性映射"
      }
    }
  ],
  "GroupTitles": {
    "en": "VACUUM and Maintenance",
    "zh-Hans": "VACUUM 与维护"
  },
  "LegacyIDs": [
    "158"
  ]
}

Complete source data JSON