Documentation / Storage Parameters / B-tree indexes
deduplicate_items
deduplicate_items
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 .
Reading PostgreSQL 18.6.
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.
- Applies to
- B-tree indexes
- Value type
- boolean
- Default
- ON
Usage
WITH (deduplicate_items = value)Index access method
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.
Related entries
Documentation and source
Source build
- Version
- 18.6
- Build
- Local English manual 18.6
- Source fingerprint
eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744
Related entries
fillfactorB-tree indexes fillfactor
Back to Storage Parameters · Recorded in PostgreSQL 13 through 20; the first sample is not necessarily its introduction.