Initplan placed at the righttree or the lefttree of joinnode
От | Hou, Zhijie |
---|---|
Тема | Initplan placed at the righttree or the lefttree of joinnode |
Дата | |
Msg-id | 133491a8ecc2456084e7050830d93202@G08CNEXMBPEKD05.g08.fujitsu.local обсуждение исходный текст |
Ответы |
Re: Initplan placed at the righttree or the lefttree of joinnode
Re: Initplan placed at the righttree or the lefttree of joinnode |
Список | pgsql-general |
Hi, I try to make some special query plan like the following. I have tried a lot SQL, but failed. Can Initplan placed at the righttree or the lefttree of joinnode? (Fake) QUERY PLAN ------------------------------------------------------------------- Hash Join (cost=13.15..26.48 rows=140 width=8) Hash Cond: (test1.a = test.a) -> Seq Scan on test1 (cost=0.00..11.40 rows=140 width=4) -> Hash (cost=11.40..11.40 rows=140 width=8) -> InitPlan 1 (returns $0,$1) Or (Fake) QUERY PLAN ------------------------------------------------------------------- Hash Join (cost=13.15..26.48 rows=140 width=8) Hash Cond: (test1.a = test.a) -> Seq Scan on test1 (cost=0.00..11.40 rows=140 width=4) -> InitPlan 1 (returns $0,$1) -> Hash (cost=11.40..11.40 rows=140 width=8) Best regards
В списке pgsql-general по дате отправления: