Goal
The path to "PostgreSQL Jissen Nyumon (A Practical Introduction to PostgreSQL)"
Here is the reading path leading up to this book, derived from its dependencies and ordered from the fundamentals.
The path so far (5 books)
Why read this first: Once you can write applied SQL, you want to understand why a query is fast or slow from the internal structure of indexes. Markus Winand's 'SQL Performance Explained' builds index design up from how B-Trees work, connecting the way you write SQL with how fast it runs.
Why read this first: After learning to read execution plans in the practical intro, dig deeper into the internal structure of indexes themselves with Winand's 'SQL Performance Explained'. Understanding index structure clarifies why a plan chooses a given access path, raising the resolution of your tuning.
Why read this first: SQL Queries for Mere Mortals concentrates on how to express SELECT, joins, subqueries and grouping in standard SQL. Once writing a WHERE clause or a join no longer takes thought, SQL Performance Explained picks up the next question about those same clauses: how they use an index.
Why read this first: After grasping RDBMS-agnostic index theory in 'SQL Performance Explained', verify how it is implemented in a concrete product via the Japanese PostgreSQL book. Touching PostgreSQL-specific index types—B-Tree, GiST, GIN, BRIN—and transaction mechanisms lands the abstract theory onto a concrete implementation.
Why read this first: After understanding PostgreSQL's internal implementation—MVCC, shared buffers—the next step is putting that knowledge to work in actual production operations. This book covers replication, backup/restore, permission management, authentication and encryption, monitoring, and performance tuning, connecting internals knowledge to concrete operational procedures.