How to speed up an st_intersects() query?
87737
Fixing performance problem in PostGIS ST_Intersects
36439
Tuning PostGIS for production environments?
141492
Optimize while and SQL in foreach
22982
Most efficient way to call same Table-Valued Function on multiple columns in a Query
123084
Finding the closest Geometry in PostGIS
144413
PostGIS doesn't use spatial index with ST_Intersects
120524
Using ST_Difference to remove overlapping features?
11315
Select query takes more time than it should
84847
How to find nearest line from point using PostGIS?
138284
Are individual queries faster than joins?
42491
How do I efficiently get "the most recent corresponding row"?
54779
A simple algorithm for polygon intersection
112066
Trying to optimize line vs cylinder intersection
66324
Performance of string comparison vs int join in SQL
90557
Extracting intersection areas in R
42364
ST_DWithin query throwing 42601 error?
146164
Speeding up a NOT IN subquery