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

PostGIS trac at osgeo.org
Mon Sep 22 08:32:14 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:  enhancement        |     Status:  reopened
  Priority:  medium             |  Milestone:  PostGIS 3.6.1
 Component:  topology           |    Version:  3.6.x
Resolution:                     |   Keywords:  performance
--------------------------------+---------------------------
Comment (by strk):

 Replying to [comment:9 Lars Aksel Opsahl]:
 > With no snapping (zero Tolerance in the Topology)

 Just a note: right now there is NO WAY to request no snapping (see #5688),
 so what where you referring to here ? Is it 0 precision in the topology
 record ? In that case a snapping tolerance is computed based on the input
 line distance from origin.

 I agree on a max_edges parameter, will work on a pull request for that.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5990#comment:13>
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