Re: enable_joinremoval

Robert Haas <robertmhaas@gmail.com> writes:
> And for the record, I believe I find it rather amusing that you're
> asking me if I "have the faintest idea how many there would be".

Actually that was directed more at Simon.

> I venture to say that after yourself I might be the person who knows
> this code best.  I know how many there will be, if I get my way, and
> that number is two.

If you're speaking of adding a switch for the materialize-insertion
behavior, I didn't object to that; I agree that turning that off might
be an interesting thing to do.  But I remain of the opinion that a
switch to disable join removal is just useless code and user-visible
complexity.
        regards, tom lane