Robert Haas <robertmh...@gmail.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers