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. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
