Speed up the calculation of cartesian bbox
|Reported by:||Algunenano||Owned by:||pramsey|
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.