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

 confirm test results

 {{{
 Linux tone 2.6.32-5-amd64 #1 SMP Tue Jun 14 09:42:28 UTC 2011 x86_64
 GNU/Linux
 AMD Opteron(tm) Processor 244
 Debian 6

 =========================
 POSTGIS="1.5.3" GEOS="3.4.0dev-CAPI-1.8.0" PROJ="Rel. 4.7.1, 23 September
 2009" LIBXML="2.7.8" USE_STATS (procs from 1.5 r5976 need upgrade)
 --
  Aggregate  (cost=3539.74..3539.75 rows=1 width=0) (actual
 time=116.831..116.832 rows=1 loops=1)
    ->  Seq Scan on gtest  (cost=0.00..3535.00 rows=1895 width=0) (actual
 time=0.306..110.354 rows=4063 loops=1)
          Filter: ((the_geom &&
 '0103000020E610000001000000090000000000000000002A40000000000000454038DB37B31D3E28403309329378F043400300000000002440000000000080434099499099C4831F403209329378F043400000000000001C40FFFFFFFFFFFF44408A499099C4831F40CCF6CD6C870F4640F8FFFFFFFFFF2340000000000080464030DB37B31D3E2840CFF6CD6C870F46400000000000002A400000000000004540'::geometry)
 AND _st_intersects(the_geom,
 '0103000020E610000001000000090000000000000000002A40000000000000454038DB37B31D3E28403309329378F043400300000000002440000000000080434099499099C4831F403209329378F043400000000000001C40FFFFFFFFFFFF44408A499099C4831F40CCF6CD6C870F4640F8FFFFFFFFFF2340000000000080464030DB37B31D3E2840CFF6CD6C870F46400000000000002A400000000000004540'::geometry))
  Total runtime: 116.941 ms

 ============
 POSTGIS="2.0.0SVN" GEOS="3.4.0dev-CAPI-1.8.0" PROJ="Rel. 4.7.1, 23
 September 2009" LIBXML="2.7.8" USE_STATS
 --
  Aggregate  (cost=3539.73..3539.74 rows=1 width=0) (actual
 time=556.648..556.650 rows=1 loops=1)
    ->  Seq Scan on gtest  (cost=0.00..3535.00 rows=1890 width=0) (actual
 time=0.267..549.223 rows=4067 loops=1)
          Filter: ((the_geom &&
 '0103000020E610000001000000090000000000000000002A40000000000000454038DB37B31D3E28403309329378F043400300000000002440000000000080434099499099C4831F403209329378F043400000000000001C40FFFFFFFFFFFF44408A499099C4831F40CCF6CD6C870F4640F8FFFFFFFFFF2340000000000080464030DB37B31D3E2840CFF6CD6C870F46400000000000002A400000000000004540'::geometry)
 AND _st_intersects(the_geom,
 '0103000020E610000001000000090000000000000000002A40000000000000454038DB37B31D3E28403309329378F043400300000000002440000000000080434099499099C4831F403209329378F043400000000000001C40FFFFFFFFFFFF44408A499099C4831F40CCF6CD6C870F4640F8FFFFFFFFFF2340000000000080464030DB37B31D3E2840CFF6CD6C870F46400000000000002A400000000000004540'::geometry))
  Total runtime: 556.732 ms

  ======

  }}}

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