[postgis-devel] [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.1
Component:  postgis  |     Version:  2.0.x        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by nicklas):

 There seems to be a difference in PostgreSQL 8.4 and 9.1.

 With 8.4 I get the same result as Sandro, with everything else unchanged.

 So, should we just leave this as unsolvable?

 Could anyone say something about the risk that this is happening also with
 the index in place? I would guess that it not will happen with point
 against polygon, but maybe with polygons against polygons. Then it could
 be a risk that PostGIS is preparing the wrong one of the incoming
 polygons.

 I think I have a big polygon data set someone nearby to test.

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