Author
Pavel Tolmachev
Author of PostgreSQL 18: Query Optimization and one of the authors of the accompanying QPT course. Full author, course, and publication credits are kept on the publication page.
PG18 · Query Optimization
PG18Query Optimization
Read execution plans with confidence. Follow a query from parsing to execution, understand the planner’s estimates, and tune the work that matters.
Translator
冯若航 / Vonng
Credited translator of the Simplified Chinese edition. The Chinese web edition keeps the original chapter order, figures, code examples, and PostgreSQL 18 context.
What this book covers
Make execution plans readable, explainable, and tunable
The book starts with the Airlines demonstration database and moves through query processing, sequential and index scans, sorting and grouping, join methods, planner statistics, profiling, materialization and functions, and a practical approach to query tuning.
It breaks an execution plan into concrete steps that can be observed, tested, and adjusted, so you can understand why the planner chose a plan and what evidence can help it choose a better one.
This is the English web manuscript of PostgreSQL 18: Query Optimization. The site keeps the original chapter order, figures, code, examples, and publication context, with stable figure numbering, cross references, full text search, and whole-book printing.
Chapter index
From the demonstration database to query tuning
Nine chapters follow one question: why did the planner choose this plan, and what evidence can help it choose a better one?
Edition and rights
Keep the source context, make the reading boundary clear
This site publishes the PostgreSQL 18: Query Optimization English web manuscript and its Simplified Chinese translation. The English text, original figures, version-specific behavior, chapter order, and publication credits remain subject to the original book and publisher; the Chinese edition is credited to 冯若航.