Covering indexes for GiST (INCLUDE)
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.
Indexing & Constraints
Description
Allows additional columns to be included in as "non-key" columns in a GiST index, and if requirements are met, can return data from these columns in an index-only scan.
Fore more information, please see the documentation on Index-Only Scans & Covering Indexes.
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Recorded legacy identifiers: 314
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "covering-indexes-for-gist-include",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "Covering indexes for GiST (INCLUDE)",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "Covering indexes for GiST (INCLUDE)",
"NameLocale": "en",
"GroupKey": "indexing-constraints",
"GroupName": "Indexing \u0026 Constraints",
"GroupLocale": "en",
"Ordinal": 5,
"GroupOrder": 2,
"Facts": {
"feature": {
"description": "Allows additional columns to be included in as \"non-key\" columns in a GiST index, and if requirements are met, can return data from these columns in an index-only scan.\r\n\r\nFore more information, please see the documentation on [Index-Only Scans \u0026 Covering Indexes](https://www.postgresql.org/docs/current/indexes-index-only-scans.html).",
"name": "Covering indexes for GiST (INCLUDE)",
"versions": {
"12": "Yes"
}
},
"group": "Indexing \u0026 Constraints",
"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": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "12",
"Supported": true,
"Original": "Yes"
},
{
"Version": "13",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "12",
"Supported": true,
"Original": "Yes"
},
{
"Version": "14",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "12",
"Supported": true,
"Original": "Yes"
},
{
"Version": "15",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "12",
"Supported": true,
"Original": "Yes"
},
{
"Version": "16",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "12",
"Supported": true,
"Original": "Yes"
},
{
"Version": "17",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "12",
"Supported": true,
"Original": "Yes"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "12",
"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": "Covering indexes for GiST (INCLUDE)",
"BodyHTML": "\u003cp\u003eAllows additional columns to be included in as \u0026#34;non-key\u0026#34; columns in a GiST index, and if requirements are met, can return data from these columns in an index-only scan.\u003c/p\u003e\n\u003cp\u003eFore more information, please see the documentation on \u003ca href=\"https://www.postgresql.org/docs/current/indexes-index-only-scans.html\" rel=\"nofollow\"\u003eIndex-Only Scans \u0026amp; Covering Indexes\u003c/a\u003e.\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "ffb77942c2c1a4f86b70fef7e109e836c6e0ecc0146c9fd107ed93381d578f59",
"Payload": {
"description": "Allows additional columns to be included in as \"non-key\" columns in a GiST index, and if requirements are met, can return data from these columns in an index-only scan.\r\n\r\nFore more information, please see the documentation on [Index-Only Scans \u0026 Covering Indexes](https://www.postgresql.org/docs/current/indexes-index-only-scans.html).",
"name": "Covering indexes for GiST (INCLUDE)",
"versions": {
"12": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "GiST 的覆盖索引 (INCLUDE)",
"BodyHTML": "\u003cp\u003e允许将额外的列作为\u0026#34;非键\u0026#34;列包含在 GiST 索引中，如果满足条件，可以在仅索引扫描中返回这些列的数据。\u003c/p\u003e\n\u003cp\u003e更多信息请参阅 \u003ca href=\"https://www.postgresql.org/docs/current/indexes-index-only-scans.html\" rel=\"nofollow\"\u003e仅索引扫描与覆盖索引\u003c/a\u003e 文档。\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "1799b64a55f16d5242e7c083546f5dab52729258c41dbcf06c9674d7c17c5d04",
"Payload": {
"description": "允许将额外的列作为\"非键\"列包含在 GiST 索引中，如果满足条件，可以在仅索引扫描中返回这些列的数据。\n\n更多信息请参阅 [仅索引扫描与覆盖索引](https://www.postgresql.org/docs/current/indexes-index-only-scans.html) 文档。",
"name": "GiST 的覆盖索引 (INCLUDE)"
}
}
],
"GroupTitles": {
"en": "Indexing \u0026 Constraints",
"zh-Hans": "索引和约束"
},
"LegacyIDs": [
"314"
]
}