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

PostGIS trac at osgeo.org
Mon Aug 1 18:40:32 PDT 2016


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

 FWIW, I ported IndexedFacetDistance to GEOS and exposed it in the CAPI as
 GEOSDistanceIndexed.  Using the two geometries from the table strk posted,
 the calculation timings are as follows (includes overhead of reading text
 file and parsing WKT)

 GEOSDistance: 41.7 s

 GEOSDistanceIndexed: 0.084s

 This might not be the right fit for the situation described in this
 ticket, but it seems like it could be useful to PostGIS overall.

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


More information about the postgis-tickets mailing list