[postgis-tickets] [PostGIS] #1798: Performance issue with ST_Intersects(geometry, geometry)

[PostGIS]

#1798: Performance issue with ST_Intersects(geometry,geometry)
---------------------+------------------------------------------------------
 Reporter:  nicklas  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.4
Component:  postgis  |     Version:  2.0.x        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by pramsey):

 In 9.2 on my computer the tests show no order dependence,
 {{{

 postgis21=# SELECT COUNT(*) FROM intersects_order t1, intersects_order t2
 postgis21-# WHERE ST_Intersects(t1.geom, t2.geom);
  count
 -------
   5131
 (1 row)

 Time: 6817.429 ms

 postgis21=# SELECT COUNT(*) FROM intersects_order t1, intersects_order t2
 postgis21-# WHERE ST_Intersects(t2.geom, t1.geom);
  count
 -------
   5131
 (1 row)

 Time: 6818.568 ms
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1798#comment:20>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.