All Posts

1582 articles

scaling9 min read

Accidental Full Table Scan — The Query That Brought Down Production

A query that runs in 3ms against 10,000 rows becomes a 42-second table-locking disaster against 50 million rows. One missing index, one function-wrapped column, or one implicit type cast silently disables PostgreSQL index usage. Here is how to find and fix these before they hit production.

Read →
Page 217 of 317