[postgis-tickets] [PostGIS] #2196: ST_Intersects performs worse on 2.0 than 1.5

[PostGIS]

#2196: ST_Intersects performs worse on 2.0 than 1.5
---------------------+------------------------------------------------------
 Reporter:  zwerner  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.3
Component:  postgis  |     Version:  2.0.x        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by zwerner):

 I looked at what was causing the issue and assumed it had to be postgis,
 as I didn't know how postgresql would make it that much slower. Of course
 it does make sense to compare versions of postgis on the same version of
 postgresql to rule it out, and I will try to do that soon. I think I will
 also try it on 9.1 vs 9.2 and see if that helps.

 If postgresql is the problem, is there a way to fix it? Or do I just
 submit a bug to them and hope for the best?

 As for the times, you can see on the first line of each blurb (actual
 time='<start time>..<end time>'): 4896.323 vs 11424.818.

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