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

[PostGIS]

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

Comment(by robe):

 The plans look pretty much the same except in the 2.0 the cost estimate
 for this part is much worse than 1.5.  I assume you already did a vacuum
 analyze of the tables.


 {{{

                ->  Index Scan using i_specie_nome_specie_like on specie
 principale  (cost=0.01..8.28 rows=319 width=57) (actual time=0.064..0.526
 rows=74 loops=1)
 }}}

 Can you remove the ST_AsGML just to rule out a memory leak in that
 function and tell me what the timings are without that.

 Also would it be possible to provide us the data.  If its private, you can
 send me download info at lr at pcorp.us and I'll test it against my 1.5
 and 2.0 to see if I see similar issues or if its specific to your
 platform.

 Thanks,
 Regina

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