pgbook
Curated by pgbook.dev • Added 2026-05-20
PostgreSQL internals and practical patterns, one concise topic at a time
No 1,000-page manual. pgbook is an open-source, terminal-friendly reference that breaks down PostgreSQL storage engines, MVCC, index types (B-tree, GIN, BRIN), query planning, and lock contention with concise, interactive examples.
What You Will Learn
- ✓PostgreSQL internal page architecture, tuple headers, and WAL logging mechanics
- ✓Choosing the optimal index: when to leverage B-tree, Hash, GIN, GiST, or BRIN
- ✓Diagnosing slow queries using EXPLAIN (ANALYZE, BUFFERS) and optimizer cost estimates
- ✓Concurrency, transaction isolation levels, and avoiding deadlocks in high-throughput apps
Curator Highlights
- ★Ultra-minimal, fast terminal-ready UI
- ★No fluff, high-signal engineering
- ★100% open source and pragmatic
Related in Data Science & Analytics
Other vetted resources in this discipline
SQLBolt
Data Science & Analytics•Interactive
Interactive in-browser lessons to master SQL queries quickly
