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

[Ethan Alpert]

In my previous posts on this I gave my results with distance =0 it
reduced my time down to 30 minutes...still far slower than the 2 minutes
queryByShape takes.

-e

-----Original Message-----
From: strk at refractions.net [mailto:strk at refractions.net] 
Sent: Wednesday, September 07, 2005 12:41 PM
To: Ethan Alpert
Cc: PostGIS Users Discussion
Subject: Re: [postgis-users] Why does this take almost 3 hours?


On Tue, Aug 30, 2005 at 11:00:35AM -0600, Ethan Alpert wrote:
> 
> I need real intersection and queryByShape() produces the exact same 
> selection as my postgis query.

Ethan, did/could you try using distance(geom,geom) = 0 ?
We're reasoning about speeding up strategies for your kind of query

--strk;