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 по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: [HACKERS] Postgres process invoking exit resulting in sh-QUIT core
Следующее
От: Mithun Cy
Дата:
Сообщение: Re: [HACKERS] Proposal : For Auto-Prewarm.