[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