[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 04:52:38 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 Lars Aksel Opsahl):

 Replying to [comment:17 strk]:
 > At the moment if you run `TopoGeo_addLinestring('topology',geom,0)` you
 get to use the precision in the topology.topology record where
 name='topology', and if that is also 0 you get to use an automatically
 computed snapping tolerance.
 >
 So what happens if I use TopoGeo_addLinestring('topology',geom,0) and the
 precision in the topology.topology is 1e-07 ?
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5990#comment:18>
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