PostGIS and SQL lover and teacher. Worked with 3D city models, traffic data and currently providing DBaaS solutions at Zalando.
Indexing OSM data in your PostGIS database for fast spatial queires is not as straight foreward as one migth hope. And with each release of PostgreSQL / PostGIS there are more options to try out. This talk will explain different spatial indexing concepts and best practices in PostGIS and present some benchmarking results.