On Sat, 28 Dec 2024 at 00:34, <msalais@xxxxxxx> 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
