Skip scan on multicolumn B-tree indexes
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
Improve execution time for queries that omit an = condition on one or more prefix index columns.
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "skip-scan-on-multicolumn-b-tree-indexes",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "Skip scan on multicolumn B-tree indexes",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "Skip scan on multicolumn B-tree indexes",
"NameLocale": "en",
"GroupKey": "indexing-constraints",
"GroupName": "Indexing \u0026 Constraints",
"GroupLocale": "en",
"Ordinal": 24,
"GroupOrder": 2,
"Facts": {
"feature": {
"description": "Improve execution time for queries that omit an `=` condition on one or more prefix index columns.",
"name": "Skip scan on multicolumn B-tree indexes",
"versions": {
"18": "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": "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": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "18",
"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": "Skip scan on multicolumn B-tree indexes",
"BodyHTML": "\u003cp\u003eImprove execution time for queries that omit an \u003ccode\u003e=\u003c/code\u003e condition on one or more prefix index columns.\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "0a622beee67a8a3105b5fb137b5686fd99e958ff4c09f2316456376e37fddb9e",
"Payload": {
"description": "Improve execution time for queries that omit an `=` condition on one or more prefix index columns.",
"name": "Skip scan on multicolumn B-tree indexes",
"versions": {
"18": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "多列 B-树 索引上的跳跃扫描",
"BodyHTML": "\u003cp\u003e对于在一个或多个前导索引列上缺少 \u003ccode\u003e=\u003c/code\u003e 条件的查询，多列 B-树 索引现在可以使用跳跃扫描来改善执行时间。\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "b338d4c80bf896eefc6e48f88e52c8dbc775cba538355a9a215bcfd12c6b07ba",
"Payload": {
"description": "对于在一个或多个前导索引列上缺少 `=` 条件的查询，多列 B-树 索引现在可以使用跳跃扫描来改善执行时间。",
"name": "多列 B-树 索引上的跳跃扫描"
}
}
],
"GroupTitles": {
"en": "Indexing \u0026 Constraints",
"zh-Hans": "索引和约束"
}
}