";
Cc: "pgsql-hackers";
Subject: Re: [HACKERS] One question about transformation ANY Sublinks into
joins
On Sun, Jul 17, 2016 at 5:33 AM, Armor wrote:
> Hi
> I run a simple SQL with latest PG??
> postgres=# explain select * from t1 where i
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,
t2.c2
and hash join condition is (t1.id1 = t2.id2) AND (t1.c1
On Sun, Jul 17, 2016 at 5:33 AM, Armor wrote:
> Hi
> I run a simple SQL with latest PG：
> postgres=# explain select * from t1 where id1 in (select id2 from t2 where
> c1=c2);
> QUERY PLAN
>
> Seq Scan on t1
Hi
I run a simple SQL with latest PG??
postgres=# explain select * from t1 where id1 in (select id2 from t2 where
c1=c2);
QUERY PLAN
Seq Scan on t1 (cost=0.00..43291.83 rows=1130 wi
