Topic
Articles on diagnosing and improving database performance, including query execution, indexing, memory usage, I/O, and production bottlenecks.
Published in this topic
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 article