[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):

 Interesting enough, commented-out tests in
 regress/core/estimatedextent.sql show that even the index-provided read
 can be dirty, and only becomes accurate on VACUUM FULL. Still, it at least
 possible to make it accurate (by runnign VACUUM) while this is impossible
 to do with pg_statistic, looks like.

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