Category
Production database debugging, query performance, indexing, capacity, and practical operational guidance.
7 articles
Database
18 min read
Learn how PostgreSQL connection pooling works, why increasing pool size can hurt performance, how to size pools across multiple application instances, and when to use PgBouncer.
Database
19 min read
Learn how PostgreSQL indexes work, why B-tree indexes make queries faster, how composite and partial indexes work, and how to verify whether an index actually improves your query.
Database
18 min read
Learn to read PostgreSQL execution plans, row estimates, scans, joins, sorts, buffers, and loops so you can diagnose slow production queries with evidence.
Database
7 min read
How concurrent updates cause lost data, what PostgreSQL MVCC does and does not prevent, and when to use atomic writes, optimistic locking, or row locks.
Database
7 min read
Why a query that is fast on test data becomes slow in production, with practical PostgreSQL checks for plans, indexes, statistics, locks, concurrency, and cache effects.
Database
7 min read
Why replication lag causes stale reads after writes, and how primary routing, consistency windows, session stickiness, version checks, and LSN-based techniques restore read-after-write behavior.
Database
17 min read
A practical production debugging guide for investigating sudden database CPU spikes, finding expensive queries, reading execution plans, checking indexes, connections, traffic, and recent changes.