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 . 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.
Reading PG 18·Select a recorded version
- Applies to
- B-tree indexes
- Value type
- boolean
- Default
- ON
- signature
- WITH (deduplicate_items = value)
Definition PG 18
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.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744
Text language: en · eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744