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

On Sat, Mar 12, 2016 at 2:02 PM, Mithun Cy <mithun(dot)cy(at)enterprisedb(dot)com>
wrote:
>
>
>
> On Sat, Mar 12, 2016 at 12:28 PM, Amit Kapila <amit(dot)kapila16(at)gmail(dot)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