Index Access Method Changes

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

Reading PostgreSQL 16.15.

Version comparison

No differences in documented capability states or storage-option inventory between these samples.

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 16.15

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	Yes	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