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

 Well, here is something weird... I first created a repro on my original
 data (repro 1), then on somewhat simplified data (repro 2), then on
 further simplified data (repro 3). Now repro 3 (what I posted above) no
 longer works - the index gets used no matter what I do! Repro 2 still
 works, though. What's more, the problem now occurs even outside of a
 transaction (in repro 2)! This is still on the same DB server, same
 versions of Postgres and PostGIS, so I don't know what's changed, other
 than the phase of the moon!

 Here is the data for it: https://www.sendspace.com/file/h0sy1y
 Restore the 2 tables and run bug3065_repro2.sql.

 My show stuff is the same: 1MB work_mem, 128MB shared_buffers.

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