GiST news and prospects
summary
GiST sees concrete gains: predicate locking reduces serializable conflicts, covering columns in Postgres 12 let non-indexable columns be returned by index-only scans (bugs later fixed), and Postgres 13 reworks VACUUM to reuse deleted pages and adds an efficient integer set. A new pre-sorted build plus sort support (PG14–15) yields up to 10× faster builds, indexes about 2× smaller and 2× faster queries on spatial data. Ongoing work: gsb3 type support, R*-style trees, inter-page indexing, and possible move to contrib.
AI-written summary · about
chapters (13)
- 0:00Introduction and speaker intro
- 1:51History and origins of GiST
- 4:44GiST in PostGIS and core usage
- 6:30Predicate locking in GiST
- 6:52Covering indexes in PostgreSQL 12
- 10:58Faster vacuum in PostgreSQL 13
- 13:06GiST vacuuming improvements
- 17:21Faster index creation in PostgreSQL 14
- 21:32KN search performance issues
- 23:43GiST build improvements in PostgreSQL 15
- 27:41Future GiST developments and patches
- 30:51Community contributions and thanks
- 31:47Q&A session
related talks
53mOn Beyond Data Types
52mBoosting Typical Query Patterns: PostgreSQL 18's Performance Enhancements
50mImproving Postgres' Efficiency
16mAll the Postgres Things
34mPostgres 10, Performance, and You
55mWhat's New in PostgresSQL 9.3
42mPostgreSQL Tips & Tricks For App Devs
49mFlexible Indexing with Postgres