Performance improvements and new use scenarios for SPGiST access method
summary
Describes improvements to PostgreSQL's SPGiST index: adding the ability to store non-key columns inside a single-column SPGiST index (similar to GiST and B-tree INCLUDE), enabling index-only scans for multicolumn queries and allowing inclusion of columns whose types lack SPGiST opclasses. Presents rationale, new use cases for GiST/SPGiST, and performance benchmarks.
AI-written summary · about
