On Fri, Feb 18, 2011 at 01:52:47PM +1030, james.sew...@lisasoft.com wrote:

> The issue I have noticed is that the newer version is noticeably (more than 
> 5x) slower on some large queries of the form:
> 
>       SELECT a.geom FROM left AS a, right AS b    
>               WHERE st_intersects(a.the_geom, b.the_geom);
> 
> 
> Have there been changes in this area of the code? Is this expected for 
> nightly builds? Is there anything I can do to help troubleshooting of the 
> issue? All my tables are imported and indexed by the same tool in both 
> instances.

If you can, compare again, using _st_intersects (skips the index).
And keep track of GEOS svn id of the source if they are different.

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html
_______________________________________________
geos-devel mailing list
geos-devel@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/geos-devel

Reply via email to