2, 2016 00:23 AM
Subject: Re: [HACKERS] One question about transformation ANY Sublinks into
On Sun, Jul 17, 2016 at 5:33 AM, Armor <yupengst...@qq.com> wrote:
On Thu, Jul 21, 2016 at 9:53 PM, Robert Haas 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,
and hash join condition is
On Sun, Jul 17, 2016 at 5:33 AM, Armor wrote:
> I run a simple SQL with latest PG：
> postgres=# explain select * from t1 where id1 in (select id2 from t2 where
> QUERY PLAN
I run a simple SQL with latest PG??
postgres=# explain select * from t1 where id1 in (select id2 from t2 where
Seq Scan on t1 (cost=0.00..43291.83 rows=1130