PostGIS Spatial Queries and Performance Tuning
Presented by:
Ryan Lambert
RustProof Labs
PostgreSQL is my database of choice; skydiving is my adrenaline rush of choice!
I started my technology-heavy career in 2003 working in the professional audio industry from a computing perspective. By 2008 I had become fully immersed in the world of databases, programming, and automating away tedious data-related tasks for the office. PostGIS was the driving force behind my initial use, and eventual love, of PostgreSQL.
This session is a deep dive into complex spatial queries and performance tuning with PostGIS. Common performance headaches are explored with a variety of approaches to remedy. GIST indexes, proper data modeling, and materialized views are demonstrated.
- Date:
- 2020 February 11 11:00 UTC
- Duration:
- 1 h
- Room:
- Online
- Conference:
- Postgres Webinar Series
- Language:
- Track:
- GIS
- Difficulty:
- Requires Registration:
- Yes (Registered: 94)