The Whole Truth About Indexes in PostgreSQL
summary
Detailed overview of indexes in PostgreSQL, explaining types of indexes (B-tree, GiST, GIN, BRIN, etc.), how they work and when to use each one. Covers indexing problems in high-load systems, trade-offs like maintenance and query planning, and practical approaches to choose and tune indexes for performance.
AI-written summary · about
chapters (11)
- 0:00Introduction
- 1:09Indexes as silver bullet
- 6:13When to use indexes
- 12:02Index scan types
- 17:06Index creation parameters
- 23:27Concurrent index creation
- 27:59Index usage examples
- 33:18Index Only Scan and visibility
- 36:41Optimizer tuning
- 40:53Partial and functional indexes
- 44:08Q&A
related talks
53mAdvanced Indexing Techniques in PostgreSQL
52mA Deep Dive into PostgreSQL Indexing
29mPostgres Index types and where to find them
46mA Deep Dive Into PostgreSQL Indexing
02h 01mIndexes in PostgreSQL. How to Decide What to Create
49mFlexible Indexing with Postgres
01h 00mFlexible Indexing With Postgres
37mRules of Indexing in PostgreSQL