Slow performance from pgres
Closed this issue · 0 comments
Ccantey commented
From John
Use spatial indexing
http://revenant.ca/www/postgis/workshop/indexing.html
If you just transform the geometry once to 4326 instead of doing it every query and change ST_Contains to ST_Intersects you'll be a bit quicker