Last Updated: November 21, 2025
Index Choices
| Index | Use case |
|---|---|
B-tree
|
Equality + range predicates |
GIN
|
Full-text search or array containment |
BRIN
|
Large time-series tables |
Commands
EXPLAIN ANALYZE
Inspect query plans
VACUUM (FULL)
Reclaim space
ALTER SYSTEM SET work_mem='16MB'
Adjust per-connection memory
Habits
Keep indexes lean, log slow queries, and prefer prepared statements when helpful.
💡 Pro Tip:
Monitor autovacuum stats, add indexes for frequent predicates, and tune work_mem for joins.