[postgis-users] Why does this take almost 3 hours?

[strk at refractions.net]

On Tue, Aug 30, 2005 at 01:44:38PM -0400, Stephen Woodbridge wrote:
> Have you tried "contains() or touches()" instead of intersects() to see 
> if the algorithm is more efficient.

both contains() and touches() do as intersects() compute full graph.

> There might be a need for a special case in the code that deals with 
> point geometries because the solution is often significantly more 
> trivial. I haven't looked at the code, so it might already be doing this.

No, it isn't doing it, but being a point involved a
distance(geom, geom) = 0 would use the "simple" algorithm
(point_in_polygon test) ...

--strk;