Robert Haas <robertmhaas@gmail.com> writes:
> OK, I'll write a patch for that; and a consensus emerges that we
> should also have enable_joinremoval, then I will add that as well. I
> think the only argument for NOT having enable_joinremoval is that you
> can always modify the query to say SELECT * rather than some more
> specific SELECT list,
Uh, no, the argument for not having enable_joinremoval is that it's
useless.
In particular, I categorically deny the argument that putting it in will
reduce user confusion. If anyone is confused because EXPLAIN shows that
some table isn't getting joined to, you think that the fact that
somewhere in the manual is a mention of enable_joinremoval will
un-confuse them? If they knew that switch was there or what it did,
they wouldn't be confused to begin with.
regards, tom lane