[postgis-users] error in geometry operations

[Paul Ramsey]

Versions of software? Don't forget to run VACUUM ANALYZE after  
creating your indexes.  How much stuff in your tables? How many a's  
in b's?  What does the EXPLAIN output of this look like?

On 20-Aug-06, at 3:12 PM, P Kishor wrote:

> -- Executing query:
> SELECT  a.id, b.id
> FROM    a, b
> WHERE   a.the_geom && b.the_geom AND WITHIN(b.the_geom, a.the_geom)
> LIMIT 10
>
> oh crap! row number -1 is out of range 0..-1
> Total query runtime: 360258 ms.
>
>
> any ideas, anyone?
>
> additionally, for a query like above, what all indexes are advised? I
> have the_geom in both tables indexed using GiST, fwiw.
>
> -- 
> Puneet Kishor http://punkish.eidesis.org/
> Nelson Inst. for Env. Studies, UW-Madison http://www.ies.wisc.edu/
> Open Source Geospatial Foundation https://edu.osgeo.org/
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users