The explain query for your query is: "Index Scan using loc_idx on metadata cat (cost=0.00..1050.88 rows=253 width=845)"
> SELECT * > 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. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
