[PostGIS] #6062: More error XX000: SQL/MM Spatial exception - geometry

[PostGIS]

#6062: More error   XX000: SQL/MM Spatial exception - geometry
--------------------------------+---------------------------
  Reporter:  Lars Aksel Opsahl  |      Owner:  strk
      Type:  defect             |     Status:  new
  Priority:  medium             |  Milestone:  PostGIS 3.6.2
 Component:  topology           |    Version:  3.6.x
Resolution:                     |   Keywords:
--------------------------------+---------------------------
Comment (by strk):

 On a closer look, the tpsnap branch doesn't really iteratively query the
 database, but it fetches the candidate target edges using the bounding box
 of the line to be snapped, so by luck it ends up (in this case) also
 fetching the bottom-right edge. It would not work if the further snaps
 would be outside the original line's bounding box (for example if the case
 was rotated so that the incoming line was horizontal). I guess this could
 be improved/fixed, which in turn could decrease performances.

 I confirm your original testcase completes with the enforced !TopoSnap
 call from within TopoGeo_addLinestring, completing in 18 minutes on my
 laptop.

 Would you be up to test the strk/lwt_tpsnap branch again your datasets, to
 see how performance is affected by the enforced !TopoSnap call ?
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/6062#comment:6>
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.