[postgis-tickets] [PostGIS] #3739: ST_Within Not using index
PostGIS
trac at osgeo.org
Sun Apr 30 12:02:49 PDT 2017
#3739: ST_Within Not using index
--------------------------+---------------------------
Reporter: postgispaul | Owner: pramsey
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 2.3.3
Component: postgis | Version: 2.3.x
Resolution: | Keywords:
--------------------------+---------------------------
Comment (by robe):
would it be a bother to provide the explain analyze? This shows the
planner thinks using the index is more costly than not, but doesn't tell
whether it is actually more costly. I would assume not - that your actual
timings would be similar to having the extra ~ condition, but hard to
tell.
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3739#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