[PostGIS] #6110: regressing in speed with geometry_columns

[PostGIS]

#6110: regressing in speed with geometry_columns
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  blocker  |  Milestone:  PostGIS 3.7.0
Component:  postgis  |    Version:  master
 Keywords:           |
---------------------+---------------------------
 As noted in https://lists.osgeo.org/pipermail/postgis-
 users/2026-July/047063.html

 geometry_columns suddenly got slower.

 I tested on my on tiger db and old view did count of 426 tables in 400ms,
 new view took 7 secs.  However all my tables are still using constraint
 based validation which could be the issue with the reporter as well.

 I tested a fix and it seems to be a simple one.  To force the CTE we added
 to NOT MATERIALIZE.  I feel like this is more a planner issue than
 anything.

 I'll test a bit more and commit.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/6110>
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.