On Sat, Jan 26, 2019 at 12:22 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Therefore, I'm reversing my previous opinion that we should not have an explicit NOT MATERIALIZED option. I think we should add that, and the behavior ought to be:
* No option given: inline if there's exactly one reference.
* With MATERIALIZED: never inline.
* With NOT MATERIALIZED: inline regardless of the number of references.
This much has been obvious to most people for a long time.