↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Versions

GIN 索引性能和大小改进

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

GIN 索引现在占用的空间显著减少,性能也比 9.4 之前的版本大幅提升。

Selected version: PostgreSQL 18

No

20191817161514131211109.69.59.49.39.29.19.08.48.38.28.18.07.4
UnknownUnknownNoNoNoNoNoYesYesYesYesYesYesYesNoNoNoNoNoNoNoNoNoNo

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 · 1bbe8e9bdce55185965a3e8bcd74801b566c7a0f8323bf5af0e406dd43ce83e2

{
  "Key": "256",
  "SourceKind": "legacy",
  "SourceDatabase": "center",
  "SourceTable": "featurematrix_feature",
  "SourceKey": "256",
  "SourceHash": "1bbe8e9bdce55185965a3e8bcd74801b566c7a0f8323bf5af0e406dd43ce83e2",
  "Name": "GIN 索引性能和大小改进",
  "NameLocale": "zh-Hans",
  "GroupKey": "13",
  "GroupName": "索引和约束",
  "GroupLocale": "zh-Hans",
  "Ordinal": 0,
  "GroupOrder": 4,
  "Facts": {
    "featuredescription": "GIN 索引现在占用的空间显著减少,性能也比 9.4 之前的版本大幅提升。",
    "featurename": "GIN 索引性能和大小改进",
    "group_id": 13,
    "id": 256,
    "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": "GIN 索引性能和大小改进",
      "BodyHTML": "\u003cp\u003eGIN 索引现在占用的空间显著减少,性能也比 9.4 之前的版本大幅提升。\u003c/p\u003e\n",
      "SourceHash": "1bbe8e9bdce55185965a3e8bcd74801b566c7a0f8323bf5af0e406dd43ce83e2",
      "ContentHash": "36c929576deb8634a3ebff4d6f8abecf4d66dd2cc199e857671f7208bd2f4326",
      "Payload": {
        "description": "GIN 索引现在占用的空间显著减少,性能也比 9.4 之前的版本大幅提升。",
        "name": "GIN 索引性能和大小改进"
      }
    }
  ],
  "GroupTitles": {
    "zh-Hans": "索引和约束"
  },
  "RelatedKey": "gin-index-performance-and-size-improvements"
}

Complete source data JSON