[postgis-tickets] [PostGIS] #5111: Topology ChangeEdgeGeometry slow at updating face MBR

[PostGIS]

#5111: Topology ChangeEdgeGeometry slow at updating face MBR
--------------------------+---------------------------
  Reporter:  strk         |      Owner:  strk
      Type:  enhancement  |     Status:  new
  Priority:  medium       |  Milestone:  PostGIS 3.3.0
 Component:  topology     |    Version:  3.2.x
Resolution:               |   Keywords:  performance
--------------------------+---------------------------

Comment (by strk):

 It takes 2 seconds to build a polygon from a set of 9295 edges. Total
 vertices in the polygon: 359909
 {{{
 00.032867 psql:run.sql:13: DEBUG:
 [../../topology/postgis_topology.c:cb_getEdgeByFace:1092]
 cb_getEdgeByFace: edge query returned 9295 rows
 00.037544 psql:run.sql:13: DEBUG:
 [../../liblwgeom/lwgeom_topo.c:lwt_GetFaceGeometry:2834]
 lwt_GetFaceGeometry: lwt_be_getEdgeByFace returned 9295 edges
 01.959255 psql:run.sql:13: DEBUG:
 [../../liblwgeom/lwgeom_topo.c:lwt_ChangeEdgeGeom:3499]
 lwt_ChangeEdgeGeom: lwt_GetFaceGeometry returned a polygon with 359909
 vertices
 }}}

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