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

PostGIS trac at osgeo.org
Tue Sep 23 09:36:42 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:  defect             |     Status:  reopened
  Priority:  medium             |  Milestone:
 Component:  topology           |    Version:  3.0.x
Resolution:                     |   Keywords:  performance
--------------------------------+-------------------------
Comment (by strk):

 Replying to [comment:18 Lars Aksel Opsahl]:

 > So what happens if I use TopoGeo_addLinestring('topology',geom,0) and
 the precision in the topology.topology is 1e-07 ?

 In that case the operation will run with tolerance 1e-07
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5990#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