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

 I'm still surprised by the excess time.
 Note that using ST_Intersects(ST_Buffer(a,10), b) takes about 200ms.
 Given the topology use for mindistance2d is to find out if the geometry is
 within a given amount of units from each other, I guess the check could be
 replaced with those two calls to GEOS.

 But the extreme difference in time seems to suggest there's something
 fundamentally wrong with the distance algorithm. Is there any way to
 access the older algorithm, fully brute force, from SQL ?

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