Indexes in PostgreSQL. How to Decide What to Create
summary
Postgres indexes: which types to create and when. Covers practical examples and rules of thumb for choosing and building indexes in PostgreSQL to improve query performance, based on a DBA’s experience, with reproducible demonstrations for real databases.
AI-written summary · about
chapters (10)
- 0:00Introduction
- 10:30What are indexes
- 23:24Checklist before index
- 30:47PostgreSQL index types
- 41:06Example 1: partial indexes
- 56:17Example 2: query optimization
- 1:06:20Example 3: analytics
- 1:23:05Column order in index
- 1:32:33Removing unused indexes
- 1:57:57Q&A
related talks
47mThe Whole Truth About Indexes in PostgreSQL
29mPostgres Index types and where to find them
52mA Deep Dive into PostgreSQL Indexing
53mAdvanced Indexing Techniques in PostgreSQL
48mB-tree Indexes in Databases Illustrated by IndexedDB and PostgreSQL
01h 00mFlexible Indexing With Postgres
37mHow Postgres could index itself
45mA Deep Dive into PostgreSQL Indexing