[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):

 The change in https://gitlab.com/postgis/postgis/-/merge_requests/72 makes
 my testcase (which calls TopoGeo_addLineString) complete in under 0.4
 seconds whereas before the change it takes over 1.6 seconds to complete:

 With patch:
 {{{
 00.046139  topogeo_addlinestring
 00.046143 -----------------------
 00.046147                 978858
 00.046151                 978860
 00.046155                 978861
 00.046158 (3 rows)
 00.046161
 00.046164 Time: 34.366 ms
 }}}

 Without patch:
 {{{
 01.639564  topogeo_addlinestring
 01.639567 -----------------------
 01.639570                 978863
 01.639572                 978865
 01.639575                 978866
 01.639578 (3 rows)
 01.639580
 01.639583 Time: 1613.833 ms (00:01.614)
 }}}

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