On Tue, Nov 28, 2017 at 11:21 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > In short, we should get rid of all of this expensive and broken logic and > just make EPQ recheck on a foreign join be a no-op, just as it is for a > foreign base table.
I'm not sure that it is. What of 5fc4c26db5120bd90348b6ee3101fcddfdf54800? That was before I started putting "Discussion" links into commit messages as a matter of routine, but I'm pretty sure that fixed what seemed to Etsuro Fujita, Kyotaro Horiguchi, and myself to be pretty clear misbehavior. See also 385f337c9f39b21dca96ca4770552a10a6d5af24. We've put an awful lot of effort into this over the last few years; I'm a bit hesitant to believe none of that did anything. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company