[PostGIS] #5984: PostGIS selectivity is screwing up queries and forcing it to choose a spatial index when it's inappropriate

[PostGIS]

#5984: PostGIS selectivity is screwing up queries and forcing it to choose a
spatial index when it's inappropriate
-----------------------+---------------------------
  Reporter:  robe      |      Owner:  pramsey
      Type:  defect    |     Status:  new
  Priority:  critical  |  Milestone:  PostGIS 3.4.5
 Component:  postgis   |    Version:  3.5.x
Resolution:            |   Keywords:
-----------------------+---------------------------
Comment (by robe):

 Paul as you requested:

 running on the full dataset:

 {{{
 SELECT _postgis_stats('nodes', 'geom','2') ;
 }}}


 3.3.9dev

 {{{
 {"ndims":2,"size":[97,102],"extent":{"min":[3.35276,50.7374],"max":[7.23499,53.5517]},"table_features":133537504,"sample_features":30000,"not_null_features":30000,"histogram_features":30000,"histogram_cells":9894,"cells_covered":30000}
 }}}

 3.6.0

 {{{
 {"ndims":2,"size":[-2147483648,-2147483648],"extent":{"min":[3.29076,50.7371],"max":[7.2349,53.565]},"table_features":133392880,"sample_features":30000,"not_null_features":30000,"histogram_features":30000,"histogram_cells":0,"cells_covered":0}
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5984#comment:8>
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.