[postgis-tickets] [PostGIS] #3065: Spatial index on LINESTRING not used under some circumstances

[PostGIS]

#3065: Spatial index on LINESTRING not used under some circumstances
---------------------------+------------------------------------------------
 Reporter:  realityexists  |       Owner:  pramsey      
     Type:  defect         |      Status:  new          
 Priority:  medium         |   Milestone:  PostGIS 2.1.6
Component:  postgis        |     Version:  2.1.x        
 Keywords:                 |  
---------------------------+------------------------------------------------

Comment(by pramsey):

 Well, watching the selectivity calculation through both the "index used"
 (no transaction) and "index not used" (transaction) cases, it's exactly
 the same: there's stats on the airspace table but not on the _sia_segment
 table (no surprise, since it's brand new) and so the calculation falls
 back to a default selectivity. So our behaviour is consistent in both
 cases. I tend to think this is a PgSQL quirk, not a PostGIS quirk.

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