| From: | Andrei Lepikhov <lepihov(at)gmail(dot)com> |
|---|---|
| To: | Tender Wang <tndrwang(at)gmail(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Alexander Korotkov <aekorotkov(at)gmail(dot)com> |
| Subject: | Re: MergeJoin beats HashJoin in the case of multiple hash clauses |
| Date: | 2025-07-03 09:23:06 |
| Message-ID: | 2176c492-b671-409d-a2fb-0a37997befb1@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 3/7/2025 04:02, Tender Wang wrote:
>
>
> Andrei Lepikhov <lepihov(at)gmail(dot)com <mailto:lepihov(at)gmail(dot)com>> 于2025年7
> 月2日周三 22:29写道:
>
> On 30/6/2025 04:38, Tender Wang wrote:
> > Do you think it's worth doing this?
> >
> >
> > Hi all,
> >
> > I have added this patch to commitfest[1]. I'm hoping someone can
> review
> > it for me.
> It makes sense to apply. If you return the comment to its place, you
> may
> reduce the patch size even more.
>
>
> Thanks for reviewing. I returned the comment to its place. Please review
> the attached patch.
Do you really need to initialise clauses with the NIL value? I guess, it
may be avoided because later you non-alternatively init it with a copy
of hash clauses.
--
regards, Andrei Lepikhov
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Álvaro Herrera | 2025-07-03 09:31:12 | Re: ALTER TABLE ALTER CONSTRAINT misleading error message |
| Previous Message | Andrei Lepikhov | 2025-07-03 09:08:54 | Re: Reduce "Var IS [NOT] NULL" quals during constant folding |