PostGIS in Action (3rd)
Where the adventure begins

PostGIS in Action: (ed. #3) Chapter 15 - Performance Tuning

PostGIS In Action 3rd Edition Chapters    PostGIS In Action 2nd Edition Chapters    1st Edition Chapters
Download chapter code and data

When dealing with several tables at once—especially large ones—tuning queries, tables, and geometries becomes a major consideration. The way you express your queries is also important because the same logic expressed with two different SQL statements can have vastly different performance. The complexity of geometries, memory allocation, and even storage affect performance.

  • Planner basics
  • Reading plans
  • Common query patterns
  • Spatial processing for better performance
  • Influencing plans
Save 50% off on Third Edition of PostGIS In Action enter mlobe3 in the Promotional Code box when you check out. Offer ends November 25th, 2021

pgRouting: A Practical Guide is now available in Hardcopy from Hardcopy from Amazon. E-Book or Bulk discounts on Hard-copy from Locate Press.

PostGIS in Action,3rd edition MEAP    PostgreSQL: Up and Running       D3.js in Action 2nd Edition   PostGIS Cookbook 2nd edition