[PostGIS] #5750: Overestimated extent from ST_EstimatedExtent result for geography column

[PostGIS]

#5750: Overestimated extent from ST_EstimatedExtent result for geography column
-------------------------------+---------------------------
 Reporter:  strk               |      Owner:  pramsey
     Type:  defect             |     Status:  new
 Priority:  medium             |  Milestone:  PostGIS 3.5.0
Component:  postgis            |    Version:  master
 Keywords:  extent, geography  |
-------------------------------+---------------------------
 Testing after #5734 I find these estimates over large.
 Longitude -10..10 is estimated as -60..60

 From QGIS testcase:
 {{{
 strk at qgis_test=# select st_asewkt(g) from test_geog_ext;
         st_asewkt
 --------------------------
  SRID=4326;POINT(-10 -60)
  SRID=4326;POINT(-9 -54)
  SRID=4326;POINT(-8 -48)
  SRID=4326;POINT(-7 -42)
  SRID=4326;POINT(-6 -36)
  SRID=4326;POINT(-5 -30)
  SRID=4326;POINT(-4 -24)
  SRID=4326;POINT(-3 -18)
  SRID=4326;POINT(-2 -12)
  SRID=4326;POINT(-1 -6)
  SRID=4326;POINT(0 0)
  SRID=4326;POINT(1 6)
  SRID=4326;POINT(2 12)
  SRID=4326;POINT(3 18)
  SRID=4326;POINT(4 24)
  SRID=4326;POINT(5 30)
  SRID=4326;POINT(6 36)
  SRID=4326;POINT(7 42)
  SRID=4326;POINT(8 48)
  SRID=4326;POINT(9 54)
  SRID=4326;POINT(10 60)
 (21 rows)


 strk at qgis_test=# select st_extent(g::geometry) from test_geog_ext;
      st_extent
 --------------------
  BOX(-10 -60,10 60)
 (1 row)

 strk at qgis_test=# select ST_EstimatedExtent('public','test_geog_ext','g');
                                st_estimatedextent
 --------------------------------------------------------------------------------
  BOX(-60.88928484347299 -60.88928484347299,60.88928484347299
 60.88928484347299)
 (1 row)

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