[PostGIS] #5707: slow cb_getEdgeByFace seems like missing value for bbox parameter

PostGIS trac at osgeo.org
Tue Apr 2 01:43:41 PDT 2024


#5707: slow cb_getEdgeByFace seems like missing value for bbox  parameter
--------------------------------+---------------------------
  Reporter:  Lars Aksel Opsahl  |      Owner:  strk
      Type:  enhancement        |     Status:  new
  Priority:  medium             |  Milestone:  PostGIS 3.4.3
 Component:  topology           |    Version:  3.4.x
Resolution:                     |   Keywords:
--------------------------------+---------------------------
Comment (by strk):

 Great analysis!
 The expensive query is probably originating in the `_lwt_AddFaceSplit` C
 function when a new edge splits a face. In your case the face being split
 seems to be the universe face.

 Edges are fetched to update their left/right face if they now fall within
 the new face, so it does make sense to use the bounding box of the new
 face and the code DOES already pass such bounding box:
 https://git.osgeo.org/gitea/postgis/postgis/src/commit/d5ba6b71cf08baaf67d9646a7ca52d0dfb5c3e9c/liblwgeom/topo/lwgeom_topo.c#L2075

 I'm trying to figure out how that MBR ends up being NULL.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5707#comment:2>
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