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  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: Initplan placed at the righttree or the lefttree of joinnode  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: Hot backup in PostgreSQL
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Initplan placed at the righttree or the lefttree of joinnode