Backend Engineering
Backend Engineering••12 min read
Postgres EXPLAIN Cheat Sheet: Reading Query Plans Like a Pro
Postgres EXPLAIN plans: node types, cost interpretation, and six query anti-patterns to avoid.
BackendBytes Engineering Team
Read
#Database Internals
How databases implement storage engines, query planners, and transactions.
6 Articles
Articles
Backend Engineering
Backend Engineering••14 min read
Database Indexing Strategies: B-Trees, GIN, GiST, and Production Tuning
B-tree internals, composite index ordering, GIN for full-text search, partial indexes, and preventing index bloat in production.
BackendBytes Engineering Team
Read
Backend Engineering
Backend Engineering••14 min read
PostgreSQL Query Planner Internals: From EXPLAIN to Expert Tuning
How PostgreSQL's query optimizer decides, why it gets it wrong, and how to fix it with statistics targets and covering indexes.
BackendBytes Engineering Team
Read
System Design
System Design••14 min read
Understanding Raft Consensus: The Algorithm That Keeps Your Database Honest
How Raft works in production: leader election, log replication, safety guarantees, and failure modes in etcd and CockroachDB.
BackendBytes Engineering Team
Read
Backend Engineering
Backend Engineering••15 min read
Zero-Downtime Database Migrations at Scale
Schema migrations on billion-row tables without downtime: expand-contract, pg_repack, gh-ost, blue-green migrations, and rollbacks.
BackendBytes Engineering Team
Read
System Design
System Design••16 min read
Scaling Redis for High-Throughput Systems
Scale Redis: cluster sharding, hot key replication, connection pooling, pipelining, and eviction tuning for high-throughput workloads.
BackendBytes Engineering Team
Read