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.
Re: Explain [Analyze] produces parallel scan for select Into table statements. Re: Explain [Analyze] produces parallel scan for select Into table statements. |
Список | 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
>
>
>
>
> 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
В списке pgsql-hackers по дате отправления: