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

[PostGIS]

#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:
--------------------------------+---------------------------
Changes (by Lars Aksel Opsahl):

 * resolution:  fixed =>
 * status:  closed => reopened
 * type:  defect => enhancement

Comment:

 The time used with tolerance 1e-07 is surprisingly long we only talk about
 around 3700 new edges. Is the problem here that we insert edge 1 and then
 insert edge 2 and update edge 1 and continue like this. Is it possible
 that this insert can be done is way to avoid all the updates if this is
 the problem ?
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5990#comment:5>
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.