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

PostGIS trac at osgeo.org
Mon Mar 2 09:40:40 PST 2015


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

 The picksplit method should be fixed in all development branches now (2.0,
 2.1 and 2.2/trunk).
 Beside that (which you may test if you build the code yourself) you'd have
 to show the query and the explain output to get better help.

 Note that the planner decides how to access the db  based on statistics
 which may be outdated if you didn't run ANALYZE on the table after batch
 insert or update.

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