[postgis-tickets] [PostGIS] #5337: Row estimate for gist geometry index is more than 500 times smaller than actual count
PostGIS
trac at osgeo.org
Mon Feb 13 22:45:55 PST 2023
#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):
Output from _postgis_stats:
{"ndims":2,"size":[110,88],"extent":{"min":[440050,6.0488e+06],"max":[886366,6.40309e+06]},"table_features":28186628,"sample_features":30000,"not_null_features":30000,"histogram_features":29936,"histogram_cells":9680,"cells_covered":29936}
Seems reasonable to me.
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5337#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.
More information about the postgis-tickets
mailing list