Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> I like option #2. I don't really have a strong reason for that, but
> it feels intuitive to me that we err on the side of using remote
> estimates when in doubt.
If we believe that, why isn't the default value of use_remote_estimate true?
(Maybe it should be.)
Another option that should be considered is that joins should pay
attention only to the server-level setting and not to the individual
tables' settings. This would surely be cheaper to implement, and
it avoids any questions about whether to OR or AND the individual
settings.
regards, tom lane