Summary
Not DBA theory — the 20% of Postgres that carries 80% of real apps: schema design, indexing, transactions, the query patterns that matter, and the gotchas that bite in production.
Loading Why Postgres, and Why Learn It…
Loading Schema Design That Holds Up…
Loading Keys & Relationships…
Loading Indexes: The 20% That Matters…
Loading Querying Well…
Loading Transactions & Isolation…
Loading Concurrency & Locking…
Loading JSON in Postgres…
Loading Migrations Without Tears…
Loading Reading EXPLAIN…
Loading Performance & Scaling Basics…
Loading Backups, Safety & Production Gotchas…
Loading About Roger…