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.

- ✓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
- ★Ultra-minimal, fast terminal-ready UI
- ★No fluff, high-signal engineering
- ★100% open source and pragmatic
Add the Learnlists badge to your website
Show visitors that pgbook is curated and listed on Learnlists. Paste the embed code on your landing page, docs, or footer to drive verified social proof.
Select Style
Pick Standard or Compact in Light or Dark.
Copy Snippet
Includes automatic attribution & canonical link.
Paste into HTML
Compatible with React, Astro, WordPress, Webflow.
Related in Data Science & Analytics
Other vetted resources in this discipline

SQLBolt
Interactive in-browser lessons to master SQL queries quickly
