[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):

 Also on 9.1 on my computer, the tests show no order dependence.
 {{{

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

 Time: 7639.911 ms
 pramsey=# SELECT COUNT(*) FROM intersects_order t1, intersects_order t2
           WHERE ST_Intersects(t2.geom, t1.geom);
  count
 -------
   5131
 (1 row)
 }}}

  PostgreSQL 9.1.9, PostGIS 2.0svn

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1798#comment:21>
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.