Index Access Method Changes

Compare the documented capability states and storage-option inventories of PostgreSQL releases.

Reading PostgreSQL 12.22.

Version comparison

GiST

INCLUDE columns: No → Yes

SP-GiST

Distance ordering: Not established → Conditional (source coverage changed; no introduction date inferred)

This comparison covers capability states and the names of documented storage options. It does not compare every algorithm, performance characteristic, option definition or release-note change.

Capabilities in PostgreSQL 12.22

Capability	B-tree	Hash	GiST	SP-GiST	GIN	BRIN
Sorted output	Yes	No	No	No	No	No
Unique keys	Yes	No	No	No	No	No
Multiple key columns	Yes	No	Yes	No	Yes	Yes
INCLUDE columns	Yes	No	Yes	No	No	No
Index-only scans	Yes	No	Conditional	Conditional	No	No
Distance ordering	Not established	Not established	Conditional	Conditional	Not established	Not established
Parallel index scan	Yes	No	No	No	No	No
Parallel index build	Yes	No	No	No	No	No

Back to Index AM