[postgis-tickets] [PostGIS] #5120: ST_EstimatedExtent returns stats based extent even if index is present

[PostGIS]

#5120: ST_EstimatedExtent returns stats based extent even if index is present
----------------------+---------------------------
  Reporter:  strk     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 3.3.0
 Component:  postgis  |    Version:  master
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by strk):

 I've pushed a fix for this case. I'm tempted to backport it but I wonder
 if others have a different view on the matter. Paul ?

 Basically the question is: is there ANY reason why a NULL gbox fetched
 from an index found by table_get_spatial_index should not be trusted by
 ST_EstimatedExtent ?

 I don't see any reason for that. If index knows no BOX the table *must* be
 empty (while it *could* be empty when the index returns an actual box, due
 to pending vacuum ...)

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