[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