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

 When switching to the "global cache" I think I noticed a different
 strategy within the two different caching strategies (rtree and prepared).
 One of them only built the cache/prepared after hitting the same polygon
 twice (never the first time). It should be checked for that policy to be
 consistent. In other words: check if the slower code path is always
 building the cache or only after seeing it twice.

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