[postgis-users] ST_Overlaps and performance

DrYSG ygutfreund at draper.com
Wed Mar 7 10:50:00 PST 2012

The explain query for your query is:

"Index Scan using loc_idx on metadata cat  (cost=0.00..1050.88 rows=253

> FROM portal.catalog as cat 
> WHERE ST_Contains(cat.location,'SRID=4326;POINT(70.9433962 
> 41.5384615)'::geometry) OR 
>        ST_Contains(cat.location,'SRID=4326;POINT(71.9433962 
> 40.5384615)'::geometry)  ; 

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

More information about the postgis-users mailing list