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

 testing revs 7718 and 7719 (Darwin shadowfax.local 11.1.0 Darwin Kernel
 Version 11.1.0: Tue Jul 26 16:07:11 PDT 2011;
 root:xnu-1699.22.81~1/RELEASE_X86_64 x86_64)

 {{{
  r7718
 ---
  Aggregate  (cost=3539.70..3539.71 rows=1 width=0) (actual
 time=53.953..53.953 rows=1 loops=1)
    ->  Seq Scan on gtest  (cost=0.00..3535.00 rows=1878 width=0) (actual
 time=2.045..53.295 rows=4012 loops=1)
          Filter: ((the_geom &&
 '0103000020E610000001000000090000000000000000002A40000000000000454038DB37B31D3E28403309329378F043400300000000002440000000000080434099499099C4831F403209329378F043400000000000001C40FFFFFFFFFFFF44408A499099C4831F40CCF6CD6C870F4640F8FFFFFFFFFF2340000000000080464030DB37B31D3E2840CFF6CD6C870F46400000000000002A400000000000004540'::geometry)
 AND _st_intersects(the_geom,
 '0103000020E610000001000000090000000000000000002A40000000000000454038DB37B31D3E28403309329378F043400300000000002440000000000080434099499099C4831F403209329378F043400000000000001C40FFFFFFFFFFFF44408A499099C4831F40CCF6CD6C870F4640F8FFFFFFFFFF2340000000000080464030DB37B31D3E2840CFF6CD6C870F46400000000000002A400000000000004540'::geometry))
  Total runtime: 55.411 ms
 ===
 r7719
 ---
  Aggregate  (cost=3539.70..3539.71 rows=1 width=0) (actual
 time=300.967..300.967 rows=1 loops=1)
    ->  Seq Scan on gtest  (cost=0.00..3535.00 rows=1878 width=0) (actual
 time=0.272..300.245 rows=4012 loops=1)
          Filter: ((the_geom &&
 '0103000020E610000001000000090000000000000000002A40000000000000454038DB37B31D3E28403309329378F043400300000000002440000000000080434099499099C4831F403209329378F043400000000000001C40FFFFFFFFFFFF44408A499099C4831F40CCF6CD6C870F4640F8FFFFFFFFFF2340000000000080464030DB37B31D3E2840CFF6CD6C870F46400000000000002A400000000000004540'::geometry)
 AND _st_intersects(the_geom,
 '0103000020E610000001000000090000000000000000002A40000000000000454038DB37B31D3E28403309329378F043400300000000002440000000000080434099499099C4831F403209329378F043400000000000001C40FFFFFFFFFFFF44408A499099C4831F40CCF6CD6C870F4640F8FFFFFFFFFF2340000000000080464030DB37B31D3E2840CFF6CD6C870F46400000000000002A400000000000004540'::geometry))
  Total runtime: 301.024 ms
 }}}

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