[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