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

PostGIS trac at osgeo.org
Thu May 3 02:50:00 PDT 2012


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

 You are right strk, it might be something we cannot control.

 But there is some strange things happening here, which I don't really
 understand.

 I will try to add a test case showing the effect.

 The question is if can detect if there is no working index and in case of
 that I think we shouldn't use prepared geometries in those cases.

 I will try to make the ticket more complete.

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


More information about the postgis-devel mailing list