[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