Home > mailing lists

Re: One question about transformation ANY Sublinks into joins - Mailing list pgsql-hackers

From	Dilip Kumar
Subject	Re: One question about transformation ANY Sublinks into joins
Date	July 21, 2016 17:07:38
Msg-id	CAFiTN-u92gq_cXCCsbSw8oGYyd0T6T=N70fVmAG8w3g_9N1LVw@mail.gmail.com Whole thread
In response to	Re: One question about transformation ANY Sublinks into joins (Robert Haas <robertmhaas@gmail.com>)
List	pgsql-hackers

On Thu, Jul 21, 2016 at 9:53 PM, Robert Haas <robertmhaas@gmail.com> wrote:

It would need to be a Hash Semi Join rather than a Hash Join, wouldn't it?

I guess, Hash Join will do here,

because inner hash node is, on hash aggregate with group key on t2.id2, t2.c2

and hash join condition is (t1.id1 = t2.id2) AND (t1.c1 = t2.c2).

So I think these together will make sure that we don't get duplicate tuple for one outer record.

Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com

From: David Steele
Date: 21 July 2016, 16:59:57
Subject: Re: Password identifiers, protocol aging and SCRAM protocol

From: Tom Lane
Date: 21 July 2016, 17:31:59
Subject: Re: Password identifiers, protocol aging and SCRAM protocol