[postgis-tickets] [PostGIS] #4503: Speed up the calculation of cartesian bbox

[PostGIS]

#4503: Speed up the calculation of cartesian bbox
-------------------------+---------------------------
 Reporter:  Algunenano   |      Owner:  pramsey
     Type:  enhancement  |     Status:  new
 Priority:  medium       |  Milestone:  PostGIS 3.0.0
Component:  postgis      |    Version:  trunk
 Keywords:               |
-------------------------+---------------------------
 After fixing several functions not updating the bbox of the output
 geometry (ST_RemoveRepeatedPoints, ST_Simplify and ST_SnapToGrid) those
 functions have received an important performance impact; to the point
 where they might spend more time calculating the bbox than doing the
 actual work; e.g.:

 {{{
    - 97.47% ST_RemoveRepeatedPoints
 ▒
       + 32.26% lwgeom_calculate_gbox_cartesian
 ▒
       + 23.72% lwgeom_remove_repeated_points_in_place
 ▒
       + 22.67% heap_tuple_untoast_attr
 ▒
       + 16.47% gserialized2_from_lwgeom
 ▒
       + 2.31% lwgeom_from_gserialized2
 }}}

 I've made some improvements to the lwgeom_calculate_gbox_cartesian
 function to improve it's performance.

 PR in https://github.com/postgis/postgis/pull/475

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4503>
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.