Logical replication lookups with additional 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.
Replication
Description
A logical replication subscriber can use indexes other than the PRIMARY KEY to perform lookups during
UPDATE or DELETE operations,
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Recorded legacy identifiers: 404
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "logical-replication-lookups-with-additional-indexes",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "Logical replication lookups with additional indexes",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "Logical replication lookups with additional indexes",
"NameLocale": "en",
"GroupKey": "replication",
"GroupName": "Replication",
"GroupLocale": "en",
"Ordinal": 11,
"GroupOrder": 9,
"Facts": {
"feature": {
"description": "A logical replication subscriber can use indexes other than the `PRIMARY KEY` to perform lookups during\r\n`UPDATE` or `DELETE` operations,",
"name": "Logical replication lookups with additional indexes",
"versions": {
"16": "Yes"
}
},
"group": "Replication",
"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": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "16",
"Supported": true,
"Original": "Yes"
},
{
"Version": "17",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "16",
"Supported": true,
"Original": "Yes"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "16",
"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": "Logical replication lookups with additional indexes",
"BodyHTML": "\u003cp\u003eA logical replication subscriber can use indexes other than the \u003ccode\u003ePRIMARY KEY\u003c/code\u003e to perform lookups during\n\u003ccode\u003eUPDATE\u003c/code\u003e or \u003ccode\u003eDELETE\u003c/code\u003e operations,\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "8563f26c9cfd3102d0a452f80aeb2583091b3442a39dfd629c52d7ff292ff0c3",
"Payload": {
"description": "A logical replication subscriber can use indexes other than the `PRIMARY KEY` to perform lookups during\r\n`UPDATE` or `DELETE` operations,",
"name": "Logical replication lookups with additional indexes",
"versions": {
"16": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "使用额外索引的逻辑复制查找",
"BodyHTML": "\u003cp\u003e逻辑复制订阅端在执行 \u003ccode\u003eUPDATE\u003c/code\u003e 或 \u003ccode\u003eDELETE\u003c/code\u003e 时，除了 \u003ccode\u003ePRIMARY KEY\u003c/code\u003e 之外还可以使用其他索引进行查找。\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "22bc01b5d563ae4746bf61e4eb763e8803c8a0371401d8b7f49ee534b39d39c7",
"Payload": {
"description": "逻辑复制订阅端在执行 `UPDATE` 或 `DELETE` 时，除了 `PRIMARY KEY` 之外还可以使用其他索引进行查找。",
"name": "使用额外索引的逻辑复制查找"
}
}
],
"GroupTitles": {
"en": "Replication",
"zh-Hans": "复制"
},
"LegacyIDs": [
"404"
]
}