TL;DR
- postgres indexes basics
- For apps with growing DB and slow lists/filters.
Who this is for
- For apps with growing DB and slow lists/filters.
Keyword (SEO)
- postgres indexes basics
When to add an index
- Columns in WHERE/JOIN
- Sorting/pagination
- Query patterns
What not to index
- Too many indexes slow writes
- Low selectivity indexes
- No query plan review
How to verify
- EXPLAIN ANALYZE
- p95 monitoring
- Staging test with real data