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

 Not reproducing on OSX
 {{{
                                               QUERY PLAN
 ------------------------------------------------------------------------------------------------------
  Nested Loop  (cost=0.00..68054.38 rows=541720 width=8)
    ->  Seq Scan on test_poly a  (cost=0.00..1306.05 rows=14805 width=880)
    ->  Index Scan using ix__temp_line_line on _temp_line s
 (cost=0.00..4.47 rows=4 width=36)
          Index Cond: (a.border && line)
          Filter: (_st_distance(a.border, line, 0::double precision, false)
 < 1e-05::double precision)
 (5 rows)
 }}}

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