[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