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