PostgreSQL Query Optimization
A step toward query performance mastery
This book covers the essentials of PostgreSQL query performance tuning. We walk the reader through the planner’s inner workings—explaining access methods and join strategies, showing the importance of statistics, and teaching how to read execution plans and apply core tuning techniques.
It grew out of our training course on query performance tuning, which we have reshaped into a handy little book, so that key insights are never far away. You can easily read it on the subway or while waiting at a bus stop—those moments when you can’t fire up a laptop and really dig into hands-on practice.
Contents at a glance:
- Demonstration Database
- Planning and Execution
- Access Methods
- Sorting and Grouping
- Join Methods
- Statistics
- Profiling
- Materialization and Functions
- Tuning Approaches