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

PostGIS trac at osgeo.org
Wed Feb 14 04:04:04 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):

 I cannot find the second query in the source tree of `PostGIS-3.4.0
 0874ea3` either:
 {{{
 [strk at c23:/usr/local/src/postgis/postgis-3.4((HEAD detached at 3.4.0))]
 git rev-parse HEAD; git grep 'srid,precision'
 0874ea342af5392e3cd9f4e6157ef08648c9d2d8
 topology/postgis_topology.c:    "SELECT id,srid,precision,null::geometry "
 topology/test/regress/copytopology.sql:SELECT srid,precision FROM
 topology.topology WHERE name = 'CITY_data_UP_down';
 topology/test/regress/createtopology.sql:SELECT name,srid,precision,hasz
 from topology.topology
 topology/test/regress/topologysummary.sql:INSERT INTO topology.topology
 (id,name,srid,precision,hasz)
 }}}

 Are you sure that query is not coming from code external to PostGIS ?
 I'm trying to reproduce the problem of multiple queries to
 topology.topology statements being triggered by a single call to
 TopoGeo_addLineString but I've not been able so far.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5667#comment:8>
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