Indexing

Index creation, maintenance, monitoring, and optimization strategies

How-to guides

How to monitor CREATE INDEX / REINDEX progress in Postgres 12+

Difficulty: advanced • Time: 5 min

Over-indexing

Difficulty: beginner • Time: 5 min

Index maintenance

Difficulty: beginner • Time: 5 min

How to find unused indexes

Difficulty: beginner • Time: 7 min

How to find redundant indexes

Difficulty: beginner • Time: 6 min

How to rebuild many indexes using many backends avoiding deadlocks

Difficulty: intermediate • Time: 5 min