id summary reporter owner description type status priority milestone component version resolution keywords cc 536 Get rid of the STRICT on geography ST_Intersects robe pramsey "The STRICT clause on the ST_Intersects geography is preventing the planner from dissolving the function into the index + non-index constituent parts. This means it is never using the index. Removing the STRICT clause seems to fix that. See thread http://postgis.refractions.net/pipermail/postgis-users/2010-May/026831.html Haven't checked the other geography functions to see if they suffer the same issue." defect closed high PostGIS 1.5.2 postgis 1.5.X fixed