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

PostGIS trac at osgeo.org
Mon Mar 16 13:37:53 PDT 2015


#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 robe):

 realityexists if you can provide a link to the data that would be swell as
 I realize now these tables in your test are empty so might not be the same
 thing you are seeing since your plans all show a lot more records than
 ours do.

 As I recall I think I did see something somewhat bizarre with one of my
 datasets that had both a timerange column and a geometry column, but then
 I couldn't reproduce the issue.  So I suspect something might be going on
 between the gistiness of timerange and geometry which is causing some sort
 of corruption with the index.

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


More information about the postgis-tickets mailing list