[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
 Keywords:                     |
-------------------------------+-------------------
 Is is difficult to add new method for TopoGeo_AddLineString(

 {{{
 TopoGeo_AddLineString(varchar atopology, geometry aline, float8 tolerance)
 }}}

 with new method like this

 {{{
 TopoGeo_AddLineString(varchar atopology, geometry[] lines, float8
 tolerance)
 }}}

 so we can add multiple lines in a single call ?

 Can a method like this make it easier to increase performance and reduce
 the number off calls like the one below


 {{{
 total_min       |        avg_ms         |   calls   |
 query
 8.63888982881786 |  0.009448244050939514 |  54860288 | SELECT 1 FROM ONLY
 "gronn_test_03_test_topo"."face" x WHERE "face_id" OPERATOR(pg_catalog.=)
 $1 FOR KEY SHARE OF x
 9.254862599314976 |  0.010973764762885281 |  50601755 | SELECT 1 FROM ONLY
 "gronn_test_03_test_topo"."node" x WHERE "node_id" OPERATOR(pg_catalog.=)
 $1 FOR KEY SHARE OF x
 16.16802178720142 |   0.01995163239587184 |  48621651 | SELECT
 id,srid,precision,null::geometry FROM topology.topology WHERE name =
 $1::varchar

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