[PostGIS] #5959: Query planner vastly underestimates number of rows matched by GIST index

[PostGIS]

#5959: Query planner vastly underestimates number of rows matched by GIST index
----------------------+---------------------------
  Reporter:  alexobs  |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 3.5.5
 Component:  postgis  |    Version:  3.5.x
Resolution:           |   Keywords:
----------------------+---------------------------
Comment (by pramsey):

 Thanks for the bisect, that's kind of huge. This commit does include
 changes in the estimate file, I am not sure why they would induce the
 effect you are seeing, but given that most changes don't touch that file,
 I'm inclined to think you've isolated the main change. If you're feeling
 particularly spunky you could back out the
 [https://github.com/postgis/postgis/commit/8efa9b214e72d52188518a9f46859cfb98b4c612
 change] to `gserialized_estimate.c` and see if the problem goes away for
 you.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5959#comment:6>
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.