[postgis-users] ST_Overlaps and performance

[DrYSG]

Not a great improvement in performance using:

SELECT * 
FROM portal.metadata as cat 
WHERE cat.location && 'SRID=4326;POLYGON((-70.9433962 
41.5384615,-72.5283019 41.5384615,-72.5283019 41.1538462,-70.9433962 
41.1538462,-70.9433962 41.5384615))'::geometry; 


13:27:44  [SELECT - 2862 row(s), 37.360 secs]  Result set fetched
... 1 statement(s) executed, 2862 row(s) affected, exec/fetch time:
37.360/0.073 sec  [1 successful, 0 warnings, 0 errors]



--
View this message in context: http://postgis.17.n6.nabble.com/ST-Overlaps-and-performance-tp4555465p4555662.html
Sent from the PostGIS - User mailing list archive at Nabble.com.