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

 Well Like I said,  I don't think even PostgreSQL is the culprit because I
 tested 2.0 on both 8.4 and 9.2 and also tested 1.5. It could be the
 difference in your server configs.  You are using EXPLAIN ANALYZE right
 and not the time it takes to dump out the results.  The time is very
 different and can be even more so the further you are away from the
 server.

 Also I think in 2.0 the time to dump out would be longer since the
 geometries are slightly fatter.

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