[postgis-users] speed up spatial queries (distance() or intersects() or ???)

[David Blasby]

Daniel Faivre wrote:
> According to the "explain 
> analyze", this part of the request seems not time-expensive (except if I 
> misunderstand that and if these subrequest is done 5150 times ???).

This is probably whats happening.  Why dont you try a query with the 
actual geometry instead of a subselect and see if its faster?

dave