{"kind": "relopts", "major": "18", "item": {"slug": "btree-deduplicate-items", "name": "deduplicate_items", "name_zh": "deduplicate_items", "category": "B-tree indexes", "summary": "Controls usage of the B-tree deduplication technique described in Section 65.1.4.3 . Set to ON or OFF to enable or disable the optimization. (Alternative spellings of ON and OFF are allowed as described in Section 19.1 .) The default is ON .", "aliases": ["btree.deduplicate_items"], "versions": {"13": {"facts": [{"label": "Applies to", "value": "B-tree indexes"}, {"label": "Value type", "value": "boolean"}, {"label": "Default", "value": "ON"}], "related": [{"url": "/docs/sql/create-index/?v=13", "label": "CREATE INDEX"}], "release": {"ref": "Local English manual 13.23", "label": "13.23", "major": "13", "channel": "historical", "revision": "346825c2d5fbebb2bd997afbb2d49edfd782dce050c0b934e84a883e5446a99f"}, "sources": [{"url": "/docs/13/sql-createindex.html#INDEX-RELOPTION-DEDUPLICATE-ITEMS", "path": "sql-createindex.html", "label": "PostgreSQL 13 English manual", "sha256": "a02f612ec64fc7396ab65a1ce4458cd6971bbd8715e2465ae3c5927d20af3840"}], "sections": [{"title": "Index access method", "paragraphs": ["This entry applies to B-tree indexes. Set it with CREATE INDEX WITH or ALTER INDEX SET. Read defaults and behavior for this specific access method."]}], "signature": "WITH (deduplicate_items = value)", "description": ["Controls usage of the B-tree deduplication technique described in Section 63.4.2 . Set to ON or OFF to enable or disable the optimization. (Alternative spellings of ON and OFF are allowed as described in Section 19.1 .) The default is ON .", "Turning deduplicate_items off via ALTER INDEX prevents future insertions from triggering deduplication, but does not in itself make existing posting list tuples use the standard tuple representation."]}, "14": {"facts": [{"label": "Applies to", "value": "B-tree indexes"}, {"label": "Value type", "value": "boolean"}, {"label": "Default", "value": "ON"}], "related": [{"url": "/docs/sql/create-index/?v=14", "label": "CREATE INDEX"}], "release": {"ref": "Local English manual 14.24", "label": "14.24", "major": "14", "channel": "stable", "revision": "b6e7ed6d017bf1d63aae215156cde763babd657199df9fa10123733290c31260"}, "sources": [{"url": "/docs/14/sql-createindex.html#INDEX-RELOPTION-DEDUPLICATE-ITEMS", "path": "sql-createindex.html", "label": "PostgreSQL 14 English manual", "sha256": "f4d42bd08081490a491dc7bf4fa78b2a49da55ebcd0e7f843862548f7c66d70d"}], "sections": [{"title": "Index access method", "paragraphs": ["This entry applies to B-tree indexes. Set it with CREATE INDEX WITH or ALTER INDEX SET. Read defaults and behavior for this specific access method."]}], "signature": "WITH (deduplicate_items = value)", "description": ["Controls usage of the B-tree deduplication technique described in Section 64.4.3 . Set to ON or OFF to enable or disable the optimization. (Alternative spellings of ON and OFF are allowed as described in Section 20.1 .) The default is ON .", "Turning deduplicate_items off via ALTER INDEX prevents future insertions from triggering deduplication, but does not in itself make existing posting list tuples use the standard tuple representation."]}, "15": {"facts": [{"label": "Applies to", "value": "B-tree indexes"}, {"label": "Value type", "value": "boolean"}, {"label": "Default", "value": "ON"}], "related": [{"url": "/docs/sql/create-index/?v=15", "label": "CREATE INDEX"}], "release": {"ref": "Local English manual 15.19", "label": "15.19", "major": "15", "channel": "stable", "revision": "643ecd492fa284d4d55861f15cbd7c0c7451abce96c8d56485bb2729caba37d5"}, "sources": [{"url": "/docs/15/sql-createindex.html#INDEX-RELOPTION-DEDUPLICATE-ITEMS", "path": "sql-createindex.html", "label": "PostgreSQL 15 English manual", "sha256": "d0c693e7bccb80a261cfefed9f515fd2d24fb49395dfcbd61672d7915fa0666c"}], "sections": [{"title": "Index access method", "paragraphs": ["This entry applies to B-tree indexes. Set it with CREATE INDEX WITH or ALTER INDEX SET. Read defaults and behavior for this specific access method."]}], "signature": "WITH (deduplicate_items = value)", "description": ["Controls usage of the B-tree deduplication technique described in Section 67.4.3 . Set to ON or OFF to enable or disable the optimization. (Alternative spellings of ON and OFF are allowed as described in Section 20.1 .) The default is ON .", "Turning deduplicate_items off via ALTER INDEX prevents future insertions from triggering deduplication, but does not in itself make existing posting list tuples use the standard tuple representation."]}, "16": {"facts": [{"label": "Applies to", "value": "B-tree indexes"}, {"label": "Value type", "value": "boolean"}, {"label": "Default", "value": "ON"}], "related": [{"url": "/docs/sql/create-index/?v=16", "label": "CREATE INDEX"}], "release": {"ref": "Local English manual 16.15", "label": "16.15", "major": "16", "channel": "stable", "revision": "0080d7d37081f27216dc4aa4f6ad85ea24c0c0441e702e6d0b190a339fd76f62"}, "sources": [{"url": "/docs/16/sql-createindex.html#INDEX-RELOPTION-DEDUPLICATE-ITEMS", "path": "sql-createindex.html", "label": "PostgreSQL 16 English manual", "sha256": "ede5053e24573587783eee1735daf6cba76010c2773f10ad066d8cdaf7073c83"}], "sections": [{"title": "Index access method", "paragraphs": ["This entry applies to B-tree indexes. Set it with CREATE INDEX WITH or ALTER INDEX SET. Read defaults and behavior for this specific access method."]}], "signature": "WITH (deduplicate_items = value)", "description": ["Controls usage of the B-tree deduplication technique described in Section 67.4.3 . Set to ON or OFF to enable or disable the optimization. (Alternative spellings of ON and OFF are allowed as described in Section 20.1 .) The default is ON .", "Turning deduplicate_items off via ALTER INDEX prevents future insertions from triggering deduplication, but does not in itself make existing posting list tuples use the standard tuple representation."]}, "17": {"facts": [{"label": "Applies to", "value": "B-tree indexes"}, {"label": "Value type", "value": "boolean"}, {"label": "Default", "value": "ON"}], "related": [{"url": "/docs/sql/create-index/?v=17", "label": "CREATE INDEX"}], "release": {"ref": "Local English manual 17.11", "label": "17.11", "major": "17", "channel": "stable", "revision": "440f894c3464e7cb4fedc9846b948ca21cd2ffcef1697ff56a28eb641ee7c3d8"}, "sources": [{"url": "/docs/17/sql-createindex.html#INDEX-RELOPTION-DEDUPLICATE-ITEMS", "path": "sql-createindex.html", "label": "PostgreSQL 17 English manual", "sha256": "7fdb46b4a32c524457958417502f4036888552e0577352ee66f107019bbfffd6"}], "sections": [{"title": "Index access method", "paragraphs": ["This entry applies to B-tree indexes. Set it with CREATE INDEX WITH or ALTER INDEX SET. Read defaults and behavior for this specific access method."]}], "signature": "WITH (deduplicate_items = value)", "description": ["Controls usage of the B-tree deduplication technique described in Section 64.1.4.3 . Set to ON or OFF to enable or disable the optimization. (Alternative spellings of ON and OFF are allowed as described in Section 19.1 .) The default is ON .", "Turning deduplicate_items off via ALTER INDEX prevents future insertions from triggering deduplication, but does not in itself make existing posting list tuples use the standard tuple representation."]}, "18": {"facts": [{"label": "Applies to", "value": "B-tree indexes"}, {"label": "Value type", "value": "boolean"}, {"label": "Default", "value": "ON"}], "related": [{"url": "/docs/sql/create-index/?v=18", "label": "CREATE INDEX"}], "release": {"ref": "Local English manual 18.6", "label": "18.6", "major": "18", "channel": "stable", "revision": "eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744"}, "sources": [{"url": "/docs/18/sql-createindex.html#INDEX-RELOPTION-DEDUPLICATE-ITEMS", "path": "sql-createindex.html", "label": "PostgreSQL 18 English manual", "sha256": "6aa00da55815d13d0355dd25cb1cdb603fa36964993f164d1b6f486011282580"}], "sections": [{"title": "Index access method", "paragraphs": ["This entry applies to B-tree indexes. Set it with CREATE INDEX WITH or ALTER INDEX SET. Read defaults and behavior for this specific access method."]}], "signature": "WITH (deduplicate_items = value)", "description": ["Controls usage of the B-tree deduplication technique described in Section 65.1.4.3 . Set to ON or OFF to enable or disable the optimization. (Alternative spellings of ON and OFF are allowed as described in Section 19.1 .) The default is ON .", "Turning deduplicate_items off via ALTER INDEX prevents future insertions from triggering deduplication, but does not in itself make existing posting list tuples use the standard tuple representation."]}, "19": {"facts": [{"label": "Applies to", "value": "B-tree indexes"}, {"label": "Value type", "value": "boolean"}, {"label": "Default", "value": "ON"}], "related": [{"url": "/docs/sql/create-index/?v=19", "label": "CREATE INDEX"}], "release": {"ref": "Local English manual 19 beta 4", "label": "19 beta 4", "major": "19", "channel": "preview", "revision": "df6d20830d1a09734a2db6ffc3a6138ce80e669294e56a30f6b5d4a89d81aef1"}, "sources": [{"url": "/docs/19/sql-createindex.html#INDEX-RELOPTION-DEDUPLICATE-ITEMS", "path": "sql-createindex.html", "label": "PostgreSQL 19 English manual", "sha256": "e90c2051c335f6636fb68f3b03f98c3282445c537c99fd7d2e74e4943662e224"}], "sections": [{"title": "Index access method", "paragraphs": ["This entry applies to B-tree indexes. Set it with CREATE INDEX WITH or ALTER INDEX SET. Read defaults and behavior for this specific access method."]}], "signature": "WITH (deduplicate_items = value)", "description": ["Controls usage of the B-tree deduplication technique described in Section 65.1.4.3 . Set to ON or OFF to enable or disable the optimization. (Alternative spellings of ON and OFF are allowed as described in Section 19.1 .) The default is ON .", "Turning deduplicate_items off via ALTER INDEX prevents future insertions from triggering deduplication, but does not in itself make existing posting list tuples use the standard tuple representation."]}, "20": {"facts": [{"label": "Applies to", "value": "B-tree indexes"}, {"label": "Value type", "value": "boolean"}, {"label": "Default", "value": "ON"}], "related": [{"url": "/docs/sql/create-index/?v=20", "label": "CREATE INDEX"}], "release": {"ref": "2c10c2ce4d7bcd57543a49ab402af02a39724e0a", "label": "20 devel", "major": "20", "channel": "devel", "revision": "ca199fbaaf6c4bd29cd5a98beaf34d9f4141c15d2f94d1d0202f3204ef18d09f"}, "sources": [{"url": "/docs/devel/sql-createindex.html#INDEX-RELOPTION-DEDUPLICATE-ITEMS", "path": "sql-createindex.html", "label": "PostgreSQL 20 English manual", "sha256": "33a4425c008678a8009be08f283f4f536180f45ebf9f6c2183f06daa3cf385d8"}], "sections": [{"title": "Index access method", "paragraphs": ["This entry applies to B-tree indexes. Set it with CREATE INDEX WITH or ALTER INDEX SET. Read defaults and behavior for this specific access method."]}], "signature": "WITH (deduplicate_items = value)", "description": ["Controls usage of the B-tree deduplication technique described in Section 65.1.4.3 . Set to ON or OFF to enable or disable the optimization. (Alternative spellings of ON and OFF are allowed as described in Section 19.1 .) The default is ON .", "Turning deduplicate_items off via ALTER INDEX prevents future insertions from triggering deduplication, but does not in itself make existing posting list tuples use the standard tuple representation."]}}, "content_hash": "0018bd74bc3d727424a231c2acf03e6bc8711a92ae1496cd00ce39534ee05a4f", "imported_at": "2026-09-27T09:57:58.907"}, "snapshot": {"facts": [{"label": "Applies to", "value": "B-tree indexes"}, {"label": "Value type", "value": "boolean"}, {"label": "Default", "value": "ON"}], "related": [{"url": "/docs/sql/create-index/?v=18", "label": "CREATE INDEX"}], "release": {"ref": "Local English manual 18.6", "label": "18.6", "major": "18", "channel": "stable", "revision": "eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744"}, "sources": [{"url": "/docs/18/sql-createindex.html#INDEX-RELOPTION-DEDUPLICATE-ITEMS", "path": "sql-createindex.html", "label": "PostgreSQL 18 English manual", "sha256": "6aa00da55815d13d0355dd25cb1cdb603fa36964993f164d1b6f486011282580"}], "sections": [{"title": "Index access method", "paragraphs": ["This entry applies to B-tree indexes. Set it with CREATE INDEX WITH or ALTER INDEX SET. Read defaults and behavior for this specific access method."]}], "signature": "WITH (deduplicate_items = value)", "description": ["Controls usage of the B-tree deduplication technique described in Section 65.1.4.3 . Set to ON or OFF to enable or disable the optimization. (Alternative spellings of ON and OFF are allowed as described in Section 19.1 .) The default is ON .", "Turning deduplicate_items off via ALTER INDEX prevents future insertions from triggering deduplication, but does not in itself make existing posting list tuples use the standard tuple representation."]}, "comparison": {"left": "12", "right": "13", "status": "added", "diff": "--- PostgreSQL 12\n+++ PostgreSQL 13\n@@ -1 +1,18 @@\n-Not recorded in this version\n+{\n+  \"facts\": [\n+    {\n+      \"label\": \"Applies to\",\n+      \"value\": \"B-tree indexes\"\n+    },\n+    {\n+      \"label\": \"Value type\",\n+      \"value\": \"boolean\"\n+    },\n+    {\n+      \"label\": \"Default\",\n+      \"value\": \"ON\"\n+    }\n+  ],\n+  \"signature\": \"WITH (deduplicate_items = value)\",\n+  \"tables\": null\n+}"}}