[postgis-devel] [PostGIS] #1165: Selectivity extimation of && operator

[PostGIS]

#1165: Selectivity extimation of && operator
----------------------------+-----------------------------------------------
 Reporter:  edoardopanfili  |       Owner:  pramsey      
     Type:  defect          |      Status:  new          
 Priority:  blocker         |   Milestone:  PostGIS 2.0.0
Component:  postgis         |     Version:  1.5.X        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by robe):

 To rule out the random data issue I swapped my dlls and my 8/03 with the
 random generated 8/22

 finishes in: so it seems something has gone horribly wrong between 8/3 and
 8/21

 {{{
 -- 8/3/2011 compiled version --
 Aggregate  (cost=7179.77..7179.78 rows=1 width=0) (actual
 time=190.204..190.205 rows=1 loops=1)
   ->  Seq Scan on gtest  (cost=0.00..7175.00 rows=1907 width=0) (actual
 time=0.523..186.938 rows=4000 loops=1)
         Filter: ((the_geom &&
 '0103000020E610000001000000090000000000000000002A40000000000000454037DB37B31D3E28403309329378F043400300000000002440000000000080434099499099C4831F403209329378F043400000000000001C40FFFFFFFFFFFF44408A499099C4831F40CCF6CD6C870F4640F8FFFFFFFFFF2340000000000080464030DB37B31D3E2840CFF6CD6C870F46400000000000002A400000000000004540'::geometry)
 AND _st_intersects(the_geom,
 '0103000020E610000001000000090000000000000000002A40000000000000454037DB37B31D3E28403309329378F043400300000000002440000000000080434099499099C4831F403209329378F043400000000000001C40FFFFFFFFFFFF44408A499099C4831F40CCF6CD6C870F4640F8FFFFFFFFFF2340000000000080464030DB37B31D3E2840CFF6CD6C870F46400000000000002A400000000000004540'::geometry))
 Total runtime: 190.296 ms
 }}}

 -- 8/21/ compiled version --

 {{{
 Aggregate  (cost=7179.77..7179.78 rows=1 width=0) (actual
 time=774.536..774.537 rows=1 loops=1)
   ->  Seq Scan on gtest  (cost=0.00..7175.00 rows=1907 width=0) (actual
 time=0.523..770.348 rows=4000 loops=1)
         Filter: ((the_geom &&
 '0103000020E610000001000000090000000000000000002A40000000000000454037DB37B31D3E28403309329378F043400300000000002440000000000080434099499099C4831F403209329378F043400000000000001C40FFFFFFFFFFFF44408A499099C4831F40CCF6CD6C870F4640F8FFFFFFFFFF2340000000000080464030DB37B31D3E2840CFF6CD6C870F46400000000000002A400000000000004540'::geometry)
 AND _st_intersects(the_geom,
 '0103000020E610000001000000090000000000000000002A40000000000000454037DB37B31D3E28403309329378F043400300000000002440000000000080434099499099C4831F403209329378F043400000000000001C40FFFFFFFFFFFF44408A499099C4831F40CCF6CD6C870F4640F8FFFFFFFFFF2340000000000080464030DB37B31D3E2840CFF6CD6C870F46400000000000002A400000000000004540'::geometry))
 Total runtime: 774.601 ms

 }}}

 perhaps a memory leak somewhere.

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