Re: [HACKERS] Partition : Append node over a single SeqScan
От | Ashutosh Sharma |
---|---|
Тема | Re: [HACKERS] Partition : Append node over a single SeqScan |
Дата | |
Msg-id | CAE9k0Pk-=B8YYTQcXY7RB0o9iirThZfncEsT-jbLXgbmtHohYw@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: [HACKERS] Partition : Append node over a single SeqScan (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>) |
Список | pgsql-hackers |
Hi, On Wed, Jul 5, 2017 at 3:58 PM, Ashutosh Bapat <ashutosh.bapat@enterprisedb.com> wrote: > On Wed, Jul 5, 2017 at 3:48 PM, Ashutosh Sharma <ashu.coek88@gmail.com> wrote: >> Hi All, >> >> Today while exploring a bit on Range table partitioning, I could see >> that even if scan is performed on a single partition, the plan node >> has Append node in it. Isn't it a bug? > > No. See following comment from create_append_plan() > 1045 /* > 1046 * XXX ideally, if there's just one child, we'd not bother to > generate an > 1047 * Append node but just return the single child. At the > moment this does > 1048 * not work because the varno of the child scan plan won't match the > 1049 * parent-rel Vars it'll be asked to emit. > 1050 */ > Thanks for the information. -- With Regards, Ashutosh Sharma EnterpriseDB:http://www.enterprisedb.com
В списке pgsql-hackers по дате отправления: