Practical engineering notes on backend systems, architecture, databases, and production software.
Database indexes can turn a scan of millions of rows into a much smaller search. But every index also adds work to inserts, updates, and deletes. Here’s the trade-off and how to decide what deserves an index.
Read article
After increasing a PostgreSQL server from 8 GB to 32 GB of RAM, most performance problems disappeared—but one batch process remained slow. Here’s what we found and what it taught us about diagnosing database bottlenecks.
Read articleBrowse by subject.