| From: | Ronan Dunklau <ronan(dot)dunklau(at)aiven(dot)io> |
|---|---|
| To: | Richard Guo <guofenglinux(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Emre Hasegeli <emre(at)hasegeli(dot)com> |
| Subject: | Re: Using each rel as both outer and inner for JOIN_ANTI |
| Date: | 2021-07-01 07:18:37 |
| Message-ID: | 3798699.T79hNNX96L@aivenronan |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Le jeudi 1 juillet 2021, 09:09:38 CEST Ronan Dunklau a écrit :
> > Yes, thanks! I was making a big mistake here thinking the executor can
> > stop after the first match. That's not true. We need to use each outer
> > tuple to find all the matches and mark the corresponding hashtable
> > entries. I have updated the patch with the fix.
>
> It looks OK to me.
I forgot to mention: you also have failing tests due to the plans changing to
use the new join type. This might not be the case anymore once you update the
cost model, but if that's the case the tests should be updated.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2021-07-01 07:29:57 | Re: New committers: Daniel Gustafsson and John Naylor |
| Previous Message | Andrey Borodin | 2021-07-01 07:14:08 | Re: New committers: Daniel Gustafsson and John Naylor |