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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.