Category
Databases & Storage
6 articles on databases & storage.
Reading EXPLAIN ANALYZE: A Practical Guide to Postgres Query Plans
EXPLAIN ANALYZE is the most useful Postgres tool most developers can't read. Here is how to interpret a query plan and find the node that is actually slow.
Connection Pooling in Serverless: Why Postgres Falls Over and How to Fix It
Serverless plus Postgres is a footgun: every function instance opens connections until the database collapses. Here is how pooling actually fixes it.
Do You Actually Need Redis? Caching Decisions for Real Apps
Redis gets added to architectures by reflex. Here is a senior dev decision framework for when a cache earns its place, and when Postgres is enough.
PostgreSQL Indexing Explained: Which Index Type to Use and Why
A practical guide to PostgreSQL index types — B-tree, GIN, GiST, BRIN, partial, composite, and covering indexes — and exactly when to reach for each one.
Zero-Downtime Database Migrations: A Playbook
A bad migration can lock your busiest table at the worst time. The expand/contract playbook for changing a Postgres schema with zero downtime.
Postgres Full-Text Search vs a Dedicated Search Engine
Before you add Elasticsearch, check whether Postgres already does the job. Full-text search in Postgres, where it shines, and the signals it's time to move on.