[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:         
Component:  postgis        |     Version:  2.1.x  
 Keywords:                 |  
---------------------------+------------------------------------------------

Comment(by strk):

 Sorry, I meant I run the reduced test you wrote in
 http://trac.osgeo.org/postgis/ticket/3065#comment:3

 Now I've also tried on the same PostgreSQL version but with the PostGIS
 version in 2.1 branch:

 POSTGIS="2.1.6dev r13280" GEOS="3.5.0dev-CAPI-1.9.0 r4038" PROJ="Rel.
 4.8.0, 6 March 2012" GDAL="GDAL 1.11.1, released 2014/09/24"
 LIBXML="2.9.1" LIBJSON="UNKNOWN" RASTER


 Same plan:
 {{{

                                                    QUERY PLAN
 ----------------------------------------------------------------------------------------------------------------
  Nested Loop  (cost=0.14..585.98 rows=328 width=8) (actual
 time=0.003..0.003 rows=0 loops=1)
    ->  Seq Scan on test_poly a  (cost=0.00..22.30 rows=1230 width=36)
 (actual time=0.002..0.002 rows=0 loops=1)
    ->  Index Scan using ix__temp_line_line on _temp_line s
 (cost=0.14..0.45 rows=1 width=36) (never executed)
          Index Cond: (a.border && line)
          Filter: (_st_distance(a.border, line, 0::double precision, false)
 < 1e-05::double precision)
 }}}

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