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

PostGIS trac at osgeo.org
Mon Oct 20 12:30:25 PDT 2025


#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 alexobs):

 I tried bisecting it this afternoon, by marking tag '3.5.0' as bad and tag
 '3.4.3' as good, and according to git the offending commit is
 8efa9b214e72d52188518a9f46859cfb98b4c612.

 The parent commit, 4bac13b03d659fb59db1432b23c56b9e0fa604f3, indeed does
 not have the problem for me.

 I hope that's useful.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5959#comment:5>
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