On Sat, Nov 1, 2025 at 12:10 PM Hannu Krosing <[email protected]> wrote: > This reinforces my belief thet we either should have some kind of > two-level optimization, where most queries are handled quickly but > with something to trigger a more elaborate optimisation and > investigation workflow. > > Or alternatively we could just have an extra layer before the query is > sent to the database which deals with unwinding the product of > excessively stupid query generators (usually, but not always, some BI > tools :) )
I'd like to keep the focus of this thread on the patches that I'm proposing, rather than other ideas for improving the planner. I actually agree with you that at least the first of these things might be a very good idea, but that would be an entirely separate project from these patches, and I feel a lot more qualified to do this project than that one. -- Robert Haas EDB: http://www.enterprisedb.com
