[postgis-users] Very long time for a bbox/within query

[David Blasby]

Instead of the sub-queries try putting in the actual geometries (run
the sub-queries in psql and copy-and-paste in the results).  If it
runs fast, then its probably running the sub-query multiple times or
the type casting system is getting confused.

Next, I'd try removing the within() clause.  If it runs fast, then
you're spending a lot of time inside the within() function - are your
geometries complex?

dave