calendar_todayFeb 2025schedule8 min readvisibility3.2k views
PostgreSQL Indexing Strategies That Actually Helped
When a query fetching 200k rows started taking 4 seconds in production, I had to learn indexing properly. Partial indexes, composite indexes, EXPLAIN ANALYZE — a practical breakdown of what I changed and the results.
PostgreSQLPerformanceBackend
Read Postarrow_forward