[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 postgispaul):

 Wow, first: thanks for your extensive investigations!

 A couple of remarks:
 I (probably, only window is early tomorrow) won't be able to get
 reasonable timings for the next week(s) as our server is going to be doing
 some serious processing.
 I thought Bitmap index scans are always worse (or at least: not better)
 than normal index scans?
 Still doesn't explain why the condition from the function itself isn't
 taken into consideration.

 Most of the time when I encounter some weird effect in our software it
 pays off to dive in deep. It either leads to better understanding, or
 (more often than I care of) leads to a bug/edgecase/... in some deep-
 longforgotten piece of code.
 That was my main motivation to file this.

 I hope to get some additional timings for you tomorrow, will let yoy know

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