Re: [HACKERS] Partition : Append node over a single SeqScan

Поиск
Список
Период
Сортировка
От Ashutosh Bapat
Тема Re: [HACKERS] Partition : Append node over a single SeqScan
Дата
Msg-id CAFjFpRddKNJ8O7Px8iNXyDZ4nM-wYfzYT1S2Lp2VUrB4jN+idA@mail.gmail.com
обсуждение исходный текст
Ответ на [HACKERS] Partition : Append node over a single SeqScan  (Ashutosh Sharma <ashu.coek88@gmail.com>)
Ответы Re: [HACKERS] Partition : Append node over a single SeqScan  (Ashutosh Sharma <ashu.coek88@gmail.com>)
Список pgsql-hackers
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      */

--
Best Wishes,
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Ashutosh Sharma
Дата:
Сообщение: [HACKERS] Partition : Append node over a single SeqScan
Следующее
От: Dilip Kumar
Дата:
Сообщение: Re: [HACKERS] [POC] hash partitioning