[PostGIS] #5990: Adding 2 lines to Postgis topology takes 2 hours in a production line we have

PostGIS trac at osgeo.org
Mon Sep 22 00:23:14 PDT 2025


#5990: Adding 2 lines to Postgis topology takes 2 hours in a production line we
have
--------------------------------+---------------------------
  Reporter:  Lars Aksel Opsahl  |      Owner:  strk
      Type:  enhancement        |     Status:  reopened
  Priority:  medium             |  Milestone:  PostGIS 3.6.1
 Component:  topology           |    Version:  3.6.x
Resolution:                     |   Keywords:
--------------------------------+---------------------------
Comment (by Lars Aksel Opsahl):

 When I get a to a "many edges Exception", I will add the line into a
 postjob list .

 So all lines added OK with zero tolerance and a selected value for
 max_edges will be done step one.

 The postjob we will add lines that failed with tolerance 0 so then we
 adjust tolerance or maybe also max edges .

 A issue when we use snap lines to already added edges, is that it would be
 nice if end and start point did not move if possible.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5990#comment:10>
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