[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