Re: Explain [Analyze] produces parallel scan for select Into table statements.
| От | Mithun Cy |
|---|---|
| Тема | Re: Explain [Analyze] produces parallel scan for select Into table statements. |
| Дата | |
| Msg-id | CAD__OujNOskFJxEF_vnkykv1aZuiRYYjSWHskbuA7sGU0asjbQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Explain [Analyze] produces parallel scan for select Into table statements. (Amit Kapila <amit.kapila16@gmail.com>) |
| Ответы |
Re: Explain [Analyze] produces parallel scan for select
Into table statements.
|
| Список | pgsql-hackers |
On Sat, Mar 12, 2016 at 2:32 PM, Amit Kapila <amit.kapila16@gmail.com> wrote:
>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
as per user manual.
Setting this value to regress has all of the same effects as setting it to on plus some additional effect that are intended to facilitate automated regression testing. Normally, messages from a parallel worker are prefixed with a context line, but a setting of regress suppresses this to guarantee reproducible results. Also, the Gather nodes added to plans by this setting are hidden from the EXPLAIN output so that the output matches what would be obtained if this setting were turned off.
>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
as per user manual.
Setting this value to regress has all of the same effects as setting it to on plus some additional effect that are intended to facilitate automated regression testing. Normally, messages from a parallel worker are prefixed with a context line, but a setting of regress suppresses this to guarantee reproducible results. Also, the Gather nodes added to plans by this setting are hidden from the EXPLAIN output so that the output matches what would be obtained if this setting were turned off.
And my test is for EXPLAIN statements. I think under regress mode it will never fail even if parallel scan is used as per above statement.
--
В списке pgsql-hackers по дате отправления: