| From: | "Hou, Zhijie" <houzj(dot)fnst(at)cn(dot)fujitsu(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Initplan placed at the righttree or the lefttree of joinnode |
| Date: | 2020-10-22 09:43:27 |
| Message-ID: | 133491a8ecc2456084e7050830d93202@G08CNEXMBPEKD05.g08.fujitsu.local |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2020-10-22 12:17:55 | Re: Initplan placed at the righttree or the lefttree of joinnode |
| Previous Message | Andreas Joseph Krogh | 2020-10-22 09:04:47 | Re: Hot backup in PostgreSQL |