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

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

 Replying to [comment:8 strk]:
 > I cannot find the second query in the source tree of `PostGIS-3.4.0
 0874ea3`

 You mean this
 {{{
 SELECT $2 FROM ONLY "gronn_test_03_test_topo"."face" x WHERE "face_id"
 OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x
 }}} ?

 Yes this is a call triggered by the system before doing a update and not
 directly issued by any user call if I understand correctly.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5667#comment:9>
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