[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 01:41:07 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
--------------------------------+-------------------------
Changes (by strk):

 * milestone:  PostGIS 3.7.0 =>
 * type:  enhancement => defect
 * version:  3.6.x => 3.0.x

Comment:

 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.


 For the record, I've filed #5993 for the specific action of adding the
 `max_edges` parameter, so the issue title is clear. I guess we can keep
 this issue open to request an improvement of performances for when you DO
 want all those new edges.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5990#comment:17>
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