PostGIS Spatial Queries and Performance Tuning
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.
- 2020 February 11 11:00
- 1 h
- Postgres Webinar Series
- Requires Registration:
- Yes (Registered: 94)