[PostGIS] #3587: lwgeom_mindistance2d slows down topology loading

PostGIS trac at osgeo.org
Wed Mar 6 01:02:26 PST 2024


#3587: lwgeom_mindistance2d slows down topology loading
-----------------------+-----------------------------
  Reporter:  strk      |      Owner:  strk
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS Fund Me
 Component:  topology  |    Version:  2.2.x
Resolution:            |   Keywords:  performance
-----------------------+-----------------------------
Comment (by strk):

 It's useful to note that subdividing the lines before adding them into the
 topology has a great benefit in term of load time. Using `ST_Subdivide` to
 split them to have at most 256 vertices makes the whole data load in under
 30 seconds, with no change in the PostGIS code (so it would compare to the
 17 minutes run).
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3587#comment:49>
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