[postgis-tickets] [PostGIS] #3587: lwgeom_mindistance2d slows down topology loading

[PostGIS]

#3587: lwgeom_mindistance2d slows down topology loading
-----------------------+---------------------------
  Reporter:  strk      |      Owner:  strk
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 2.2.3
 Component:  topology  |    Version:  2.2.x
Resolution:            |   Keywords:  performance
-----------------------+---------------------------

Comment (by pramsey):

 There is no rtree cache used for distance in geometry currently. The start
 of the code is in liblwgeom/lwtree.c but it has never been hooked up and
 is probably rotten by now. I got pulled into circular geometry distance by
 the requirements of the tree, and never got back to it. The tree code in
 geography turned up enough cases where brute_distance() != tree_distance()
 that I have viewed hooking up the tree code as a huge task requiring piles
 of testing and and QA/QC. It would certainly be very useful for repeated
 distance testing, where the repeated side is complex.

 The only place where we have tree code that has not been pulled down into
 liblwgeom is the tree code for point-in-poly intersects true/false
 testing.

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