[PostGIS] #5667: Performance Postgis Topolgy when adding millions by using TopoGeo_AddLineString

[PostGIS]

#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 Lars Aksel Opsahl):

 Replying to [comment:3 Lars Aksel Opsahl]:
 > That was not many I think we have a ratio off about 70 call for each
 call line add latest time i checked. I the C code it seems like that info
 could be added as parameter so it could be one to one .

 I may have been wrong there with ratio, maybe more 1 to 20


 {{{

 total_min       |        avg_ms         |   calls   | query
 78.72177638407608 |   0.02124369923476904 | 222339176 | SELECT
 id,srid,precision,$2::geometry FROM topology.topology WHERE name =
 $1::varchar
 39.22709295360309 |  0.012033813981130253 | 195584341 | SELECT $2 FROM
 ONLY "gronn_test_03_test_topo"."face" x WHERE "face_id"
 OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x
 41.32200506109425 |   0.01378028794816383 | 179917888 | SELECT $2 FROM
 ONLY "gronn_test_03_test_topo"."node" x WHERE "node_id"
 OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x
 4910.569903556195 |    26.160878027420043 |  11262397 | SELECT
 ARRAY(SELECT topology.TopoGeo_addLinestring(_topology_name, new_line,
 _snap_tolerance))


 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5667#comment:5>
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.