[postgis-tickets] [PostGIS] #5337: Row estimate for gist geometry index is more than 500 times smaller than actual count

[PostGIS]

#5337: Row estimate for gist geometry index is more than 500 times smaller than
actual count
-----------------------------+---------------------------
  Reporter:  Björn Harrtell  |      Owner:  pramsey
      Type:  defect          |     Status:  new
  Priority:  medium          |  Milestone:  PostGIS 3.4.0
 Component:  postgis         |    Version:  3.2.x
Resolution:                  |   Keywords:
-----------------------------+---------------------------
Comment (by Björn Harrtell):

 Also tried _postgis_selectivity with the same bbox as mentioned in
 description which is POLYGON ((716905.5 6168346.1, 716905.5 6185703.38,
 741648.19 6185703.38, 741648.19 6168346.1, 716905.5 6168346.1)) and I get
 0.055185432031709364. Assuming that means 5.5% of 28 million that seems to
 be a good estimate, it doesn't make sense to me why the row estimate is
 2819 rows (->  Bitmap Heap Scan on geodkobjekt g  (cost=68.27..5625.92
 rows=2819 width=472)).
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5337#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.