Doubt in index subplan query
| От | Suresh |
|---|---|
| Тема | Doubt in index subplan query |
| Дата | |
| Msg-id | 387960.33875.qm@web54506.mail.re2.yahoo.com обсуждение исходный текст |
| Ответ на | Re: segfault in locking code (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: Doubt in index subplan query
|
| Список | pgsql-hackers |
<table border="0" cellpadding="0" cellspacing="0"><tr><td style="font: inherit;" valign="top">Hello,<br /><br />I have
aquery plan for a certain query<br /><br /> Nested Loop (cost=100000000.00..38761761090.50 rows=3000608 width=8)<br
/> -> Seq Scan on lineitem (cost=100000000.00..100213649.15 rows=6001215 width=8)<br /> -> Index Scan using
oindex2on myorders (cost=0.00..6442.27 rows=1 width=4)<br /> Index Cond: ("outer".l_orderkey =
myorders.o_orderkey)<br/> Filter: (subplan)<br /> SubPlan<br /> -> Index Scan using
cnationon customer (cost=0.00..12859.39 rows=5251 width=0)<br /> Index Cond: (c_nationkey = 10)<br
/><br/>How is the subplan handled by postgres at index level ? Is any sort of hashing done ?<br /><br />Thanks and
regards,<br/>Suresh<br /><br /></td></tr></table><br />
В списке pgsql-hackers по дате отправления: