Optimization Gotchas in PostGIS for Geospatial Queries

Posted by Jack McKew on Tue 11 July 2023 in Databases • Tagged with databases • 4 min read

This post will go through how techniques that are intended to speed up geospatial queries for PostGIS, sometimes have the opposite effect. The origin of this post came from building a system to evaluate whether a point was on the water or not, so we'll use that as our datasource …

Continue reading