PostGIS in Action (2nd)
Where the adventure begins
Translate:



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

1st Edition Chapters    PostGIS In Action 2nd 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

Stay tuned for our next book pgRouting: A Practical Guide published by Locate Press due out in hard-copy 4th quarter 2017. Content is now feature complete and can purchase e-Book draft and get final when goes to print.

PostGIS in Action,2nd edition MEAP      PostGIS Cookbook    PostgreSQL: Up and Running,2nd Edition    PostGIS 2 Análisis Espacial Avanzado (Spanish Edition)   
Node JS In Action, 2nd Edition    D3.js in Action