[postgis-tickets] [PostGIS] #4686: Faster bbox access for PG12+

[PostGIS]

#4686: Faster bbox access for PG12+
--------------------------+---------------------------
  Reporter:  Algunenano   |      Owner:  Algunenano
      Type:  enhancement  |     Status:  assigned
  Priority:  medium       |  Milestone:  PostGIS 3.1.0
 Component:  postgis      |    Version:  master
Resolution:               |   Keywords:
--------------------------+---------------------------

Comment (by Algunenano):

 I've been having a look and there are only a few places where I was able
 to use this:
 - ANALYZE calls.
 - _ST_PointOutside (I did this just to confirm it was useful more than
 anything).
 - postgis_getbbox
 - ST_CombineBbox(box2d, geometry)
 - ST_ClipByBox2d when the geom is either fully outside or fully inside the
 bbox.
 - ST_BoundingDiagonal

 Obviously this only affects compressed geometries.


 An example of the impact:
 {{{
 -- 13 big polygons (~260843 vertices on avg)
 ANALYZE benchmark_4c7214d90a79aa6760367a084a4d4a2f61fbe1c6cc4f7f9e76020
 (the_geom, the_geom_webmercator);
 -- Master: 67.960
 -- Faster bbox: 2.315
 }}}

 It's currently living in
 https://github.com/Algunenano/postgis/tree/faster_box. I'll create a PR
 next week with some more numbers.

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