[postgis-tickets] [PostGIS] #75: Enhancement to PIP short circuit

[PostGIS]

#75: Enhancement to PIP short circuit
--------------------------+---------------------------
  Reporter:  kneufeld     |      Owner:  kneufeld
      Type:  enhancement  |     Status:  assigned
  Priority:  low          |  Milestone:  PostGIS 2.3.0
 Component:  postgis      |    Version:  trunk
Resolution:  new          |   Keywords:
--------------------------+---------------------------

Comment (by dbaston):

 I've updated the pull request to extend the PIP code to cover MultiPoints
 in ST_Intersects, ST_Contains, ST_Covers, and ST_Within.  Initially I was
 limiting this to MultiPoints with only a few members, but I've removed
 these restrictions - if the PostGIS PIP code is faster than GEOS for 1 PIP
 test (and it is), then it should be faster than GEOS for 100 PIP tests
 (and it is).

 I think I'm misunderstanding something about the RTree side of this
 process, though.  From profiling, the geos_intersects function is spending
 50% of its time creating and destroying RTrees, but I'm having trouble
 getting it to ever _use_ those RTrees.  What type of query is needed for
 the caching behavior to kick in?

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