· 11 min read
DatabaseA practical Postgres performance guide: read query plans with EXPLAIN, index the right columns, kill N+1 queries, and pool connections so the database scales.
Read article· 11 min read
3 articles
A practical Postgres performance guide: read query plans with EXPLAIN, index the right columns, kill N+1 queries, and pool connections so the database scales.
How Postgres index-only scans avoid touching the table heap, when they kick in, and how the visibility map quietly decides everything.
A practical mental model for how database indexes really work, why they speed up reads, and the hidden costs you pay on writes.