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

 zwerner,

 The script worked fine for me.  Not sure about Paul, but I didn't get a
 chance to setup on 8.4 to do a compare and also a 9.2 with 1.5.  The issue
 that makes this tricky is that 9.2 has changed a lot too.  So not sure if
 the issue you are having is related to 9.2 or 2.0.

 For example on the geocode logic I have I had to revise some of my queries
 to work efficiently on 9.2 and at the time I ruled out 2.0 as the issue
 since I had 2.0 running on 8.4 and it worked faster.

 If you are able of installing 2.0 on 8.4 or 1.5 on 9.2 that would of
 course help comparing apples with apples.

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