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

 If I test

 {{{
 select ST_Snap(line1,line2,1e-07)
 }}}

 or (after added only the first line to the topology)

 {{{
 SELECT ST_Snap(line2, (SELECT ST_COLLECT(geom) FROM
 arstat_snap_rmsliv_2025_1579_62.edge),1e-07);
 }}}

 that only takes some hundred milliseconds and the lines also seems to
 collapse into the same line.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5990#comment:6>
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.