On Sat, 28 Dec 2024 at 00:34, <msal...@msym.fr> wrote: > Sometimes one is better and sometimes the other is best. > In Oracle, the choice is done by COST. This should be the same for > PostgreSQL. In essence, it is the same thing for views: inlining or > materializing...
I don't doubt you. However, I did already mention the cost part in the final paragraph of my email and I also hinted on why it might be more difficult than you might imagine to implement. I don't want to put anyone off making improvements in this area. I only aim to highlight that it's not trivial to do so. David