Re: MergeJoin beats HashJoin in the case of multiple hash clauses

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

In response to

Responses

Browse pgsql-hackers by date

  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