Why your Postgres index isn't being used
The planner skipped an index on a 40-million-row table. Here is how to read EXPLAIN until it tells you why.
9 min read
~/blog $ ls --by-year
Every post on Stack & Heap, newest first. Pick a topic to narrow it down.
2 posts tagged #databases · clear
The planner skipped an index on a 40-million-row table. Here is how to read EXPLAIN until it tells you why.
9 min read
Transaction pooling breaks a few things quietly. A checklist to run before you put PgBouncer in front of an app.
6 min read