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

PostGIS trac at osgeo.org
Thu Mar 19 07:42:29 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 realityexists):

 Hmm, OK, but why is the index used without the UPDATE statement? It would
 make some sense if the UPDATE caused the stats to be calculated, which
 then caused the index to be used - but in fact the opposite happens.

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