Postgres Performance Cheat Sheet

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.
← Back to Databases & APIs | Browse all categories | View all cheat sheets