[PostGIS] #5707: slow cb_getEdgeByFace seems like missing value for bbox parameter
PostGIS
trac at osgeo.org
Tue Apr 2 03:11:10 PDT 2024
#5707: slow cb_getEdgeByFace seems like missing value for bbox parameter
--------------------------------+---------------------------
Reporter: Lars Aksel Opsahl | Owner: strk
Type: enhancement | Status: closed
Priority: medium | Milestone: PostGIS 3.4.3
Component: topology | Version: 3.4.x
Resolution: fixed | Keywords:
--------------------------------+---------------------------
Comment (by Lars Aksel Opsahl):
Very nice, for record rerun test area with the new code now and we down
from 123 ms to 0.09 ms for the sane area as you see.
{{{
total_min | 0.0019957501166666656
avg_ms | 0.0966464947538336
calls | 1239
query | SELECT edge_id,left_face,right_face,geom FROM
"tmp_dyrkbarjord_04_t3_d_005".edge_data WHERE ( left_face = ANY($1) OR
right_face = ANY ($1) ) AND geom && $2
}}}
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5707#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.
More information about the postgis-tickets
mailing list