[postgis-devel] [PostGIS] #1165: performance degradation between 1.5.3 and 2.0.0SVN

[PostGIS]

#1165: performance degradation between 1.5.3 and 2.0.0SVN
----------------------------+-----------------------------------------------
 Reporter:  edoardopanfili  |       Owner:  strk         
     Type:  defect          |      Status:  assigned     
 Priority:  blocker         |   Milestone:  PostGIS 2.0.0
Component:  postgis         |     Version:  1.5.X        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by darkblueb):

 testing revs 7718 and 7719
 {{{
  r7718
 ---
   Aggregate  (cost=3539.65..3539.66 rows=1 width=0) (actual
 time=69.815..69.815 rows=1 loops=1)
    ->  Seq Scan on gtest  (cost=0.00..3535.00 rows=1858 width=0) (actual
 time=0.160..68.687 rows=3986 loops=1)
          Filter: ((the_geom &&
 '0103000020E610000001000000090000000000000000002A40000000000000454038DB37B31D3E28403309329378F043400300000000002440000000000080434099499099C4831F403209329378F043400000000000001C40FFFFFFFFFFFF44408A499099C4831F40CCF6CD6C870F4640F8FFFFFFFFFF2340000000000080464030DB37B31D3E2840CFF6CD6C870F46400000000000002A400000000000004540'::geometry)
 AND _st_intersects(the_geom,
 '0103000020E610000001000000090000000000000000002A40000000000000454038DB37B31D3E28403309329378F043400300000000002440000000000080434099499099C4831F403209329378F043400000000000001C40FFFFFFFFFFFF44408A499099C4831F40CCF6CD6C870F4640F8FFFFFFFFFF2340000000000080464030DB37B31D3E2840CFF6CD6C870F46400000000000002A400000000000004540'::geometry))
  Total runtime: 69.857 ms
 ===
 r7719
 --
  Aggregate  (cost=3539.68..3539.69 rows=1 width=0) (actual
 time=332.743..332.744 rows=1 loops=1)
    ->  Seq Scan on gtest  (cost=0.00..3535.00 rows=1870 width=0) (actual
 time=0.202..330.895 rows=3990 loops=1)
          Filter: ((the_geom &&
 '0103000020E610000001000000090000000000000000002A40000000000000454038DB37B31D3E28403309329378F043400300000000002440000000000080434099499099C4831F403209329378F043400000000000001C40FFFFFFFFFFFF44408A499099C4831F40CCF6CD6C870F4640F8FFFFFFFFFF2340000000000080464030DB37B31D3E2840CFF6CD6C870F46400000000000002A400000000000004540'::geometry)
 AND _st_intersects(the_geom,
 '0103000020E610000001000000090000000000000000002A40000000000000454038DB37B31D3E28403309329378F043400300000000002440000000000080434099499099C4831F403209329378F043400000000000001C40FFFFFFFFFFFF44408A499099C4831F40CCF6CD6C870F4640F8FFFFFFFFFF2340000000000080464030DB37B31D3E2840CFF6CD6C870F46400000000000002A400000000000004540'::geometry))
  Total runtime: 332.779 ms
 }}}

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