[PostGIS] #5667: Performance Postgis Topology when adding million lines by using TopoGeo_AddLineString

PostGIS trac at osgeo.org
Sat Feb 17 00:52:37 PST 2024


#5667: Performance Postgis Topology when adding million lines by using
TopoGeo_AddLineString
--------------------------------+-------------------------
  Reporter:  Lars Aksel Opsahl  |      Owner:  strk
      Type:  enhancement        |     Status:  new
  Priority:  medium             |  Milestone:
 Component:  topology           |    Version:  3.4.x
Resolution:                     |   Keywords:  performance
--------------------------------+-------------------------
Comment (by strk):

 The most recent work on postponing face detection to after all lines are
 loaded is in ST_CreateTopoGeo, via #5670 - that work requires computing
 *all* faces at the end, while for the case at hand (adding a bunch of
 lines into an existing topology) we would probably want to only compute
 new faces within a given bounding box, which is ticketed as #917
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5667#comment:19>
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