Index Access Method Changes

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

Reading PostgreSQL 18.6.

Version comparison

GIN

Parallel index build: No → Yes

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 18.6

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

Back to Index AM