[postgis-users] find adjacent polygons query problem

Michael Fuhr mike at fuhr.org
Sun Jul 9 18:25:55 PDT 2006


On Sun, Jul 09, 2006 at 05:58:06PM -0700, Paul Ramsey wrote:
> What are your versions? Have you run VACCUM ANALYZE?

Also, how many geometries does && find and how complex are they?
Relationship functions like distance() and touches() can be much
more expensive than the bounding-box operators.

What's the output of "EXPLAIN ANALYZE SELECT ..."?

-- 
Michael Fuhr



More information about the postgis-users mailing list