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

[PostGIS]

#5990: Adding 2 lines to Postgis topology takes a more hours in a production line
-------------------------------+---------------------------
 Reporter:  Lars Aksel Opsahl  |      Owner:  strk
     Type:  defect             |     Status:  new
 Priority:  medium             |  Milestone:  PostGIS 3.6.1
Component:  topology           |    Version:  3.6.x
 Keywords:                     |
-------------------------------+---------------------------
 Too a empty topology we first add the long thin lines and that is done in
 17 milli. secs. (picture)

 Then we add the second line which partly overlaps and have distance in
 around 2 millimeters from the first line and that takes almost 2 hours
 when running on a database with many threads and heavy on the system
 below.

 {{{
 POSTGIS="3.6.0beta1 3.6.0beta1-10-ge0e19372b" [EXTENSION] PGSQL="160"
 GEOS="3.14.0beta3-CAPI-1.20.2" (compiled against GEOS 3.13.1) PROJ="9.3.0
 NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org
 USER_WRITABLE_DIRECTORY=/tmp/proj
 DATABASE_PATH=/usr/local/share/proj/proj.db" (compiled against PROJ 9.3.0)
 LIBXML="2.9.13" LIBJSON="0.15" LIBPROTOBUF="1.3.3" WAGYU="0.5.0
 (Internal)" TOPOLOGY
 }}}

 I have attached a file with the two lines and running that on my local mac
 and that takes almost 40 minuttes and ends with (3772 rows)

 On my local mac I run


 {{{
 POSTGIS="3.5.0dev 3.4.0rc1-1310-g8349e1670" [EXTENSION] PGSQL="160"
 GEOS="3.13.0-CAPI-1.19.0" PROJ="9.5.1 NETWORK_ENABLED=OFF
 URL_ENDPOINT=https://cdn.proj.org
 USER_WRITABLE_DIRECTORY=/Users/lop/Library/Application Support/proj
 DATABASE_PATH=/opt/homebrew/Cellar/proj/9.5.1/share/proj/proj.db"
 (compiled against PROJ 9.13.0) LIBXML="2.13.0" LIBJSON="0.18" TOPOLOGY
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5990>
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.