Re: Explain [Analyze] produces parallel scan for select Into table statements.

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: Explain [Analyze] produces parallel scan for select Into table statements.
Дата
Msg-id CAA4eK1LOut7G+TgEpfsP2UZpteMP35DM6=yi8u_3xJnOtVBZkg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Explain [Analyze] produces parallel scan for select Into table statements.  (Mithun Cy <mithun.cy@enterprisedb.com>)
Ответы Re: Explain [Analyze] produces parallel scan for select Into table statements.  (Mithun Cy <mithun.cy@enterprisedb.com>)
Re: Explain [Analyze] produces parallel scan for select Into table statements.  (Mithun Cy <mithun.cy@enterprisedb.com>)
Re: Explain [Analyze] produces parallel scan for select Into table statements.  (Mithun Cy <mithun.cy@enterprisedb.com>)
Список pgsql-hackers
On Sat, Mar 12, 2016 at 2:02 PM, Mithun Cy <mithun.cy@enterprisedb.com> wrote:
>
>
>
> On Sat, Mar 12, 2016 at 12:28 PM, Amit Kapila <amit.kapila16@gmail.com> wrote
> >I don't see how this test will fail with force_parallel_mode=regress and max_parallel_degree > 0 even without the patch proposed to fix the issue in >hand.  In short, I don't think this test would have caught the issue, so I don't see much advantage in adding such a test.  Even if we want to add such a >test case, I think as proposed this will substantially increase the timing for "Select Into" test which might not be an acceptable test case addition >especially for testing one corner case.
>
>
> Without above patch the make installcheck fails for select_into.sql with below diff
>
> when
> force_parallel_mode = on
> max_parallel_degree = 3
>

With force_parallel_mode=on, I could see many other failures as well.  I think it is better to have test, which tests this functionality with force_parallel_mode=regress


With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [PATCH] Use MemoryContextAlloc() in the MemoryContextAllocZero() and MemoryContextAllocZeroAligned()
Следующее
От: Alexander Korotkov
Дата:
Сообщение: Re: Background Processes and reporting