[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 23:41:00 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.7.0
 Component:  topology           |    Version:  3.6.x
Resolution:                     |   Keywords:  performance
--------------------------------+---------------------------
Comment (by Lars Aksel Opsahl):

 Replying to [comment:13 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.
 >

 Yes when  0 precision in the topology record and about this.

 if I run  TopoGeo_addLinestring('topology',geom,**0**) will there be any
 difference in snapping rules depending precision value in the topology
 record for a call like this ?
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5990#comment:16>
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