[postgis-tickets] [PostGIS] #3739: ST_Within Not using index

[PostGIS]

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

 Well geometry_contains is  a bounding box check, defined here:
 http://postgis.net/docs/doxygen/2.3/df/d5e/gserialized__gist__2d_8c_source.html#l00779

 which ultimately relies on: box2df_contains

 http://postgis.net/docs/doxygen/2.3/df/d5e/gserialized__gist__2d_8c_source.html#l00294

 if you switch the order, you may get a different answer (fewer results)
 and it would also affect the query optimizer.
 Do you get different results? I would expect so.
 .

 The order from the function at spot glance looks correct.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3739#comment:10>
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.