[PostGIS] #5667: Performance Postgis Topolgy when adding millions by using TopoGeo_AddLineString
PostGIS
trac at osgeo.org
Wed Feb 14 00:26:52 PST 2024
#5667: Performance Postgis Topolgy when adding millions by using
TopoGeo_AddLineString
--------------------------------+-------------------
Reporter: Lars Aksel Opsahl | Owner: strk
Type: enhancement | Status: new
Priority: medium | Milestone:
Component: topology | Version: 3.4.x
Resolution: | Keywords:
--------------------------------+-------------------
Comment (by strk):
How many calls to TopoGeo_AddLineString resulted in over 48 million
selects to the topology.topology table ? That query comes from the C
topology library that takes care of loading the topology. I guess some
cache could be put in place to avoid those repeated calls.
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5667#comment:1>
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