Chapter 15. Query performance tuning
This chapter covers:
Planner basics
Reading plans
Common query patterns
Spatial processing for better performance
Influencing plans
When dealing with several tables at once—especially large ones—tuning queries becomes a major consideration. The way you write your queries is also important. Two queries can return exactly the same data, but one can take a hundred times longer to finish. The complexity of spatial objects, memory allocation, and even storage affects performance.
In this chapter, you’ll learn
- How to use the planner and read query plans
- How to write efficient queries
- How to monitor query performance
- How to organize spatial data to improve query performance
Much of this information has more to ...
Get PostGIS in Action, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
