[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