[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