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__OugMshfKP05vUG1cgc8RggJqWfGS12JGSjp5gMqh8q83vw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Explain [Analyze] produces parallel scan for select Into table statements.  (Amit Kapila <amit.kapila16@gmail.com>)
Список 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. 

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.
--
Thanks and Regards
Mithun C Y

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

Предыдущее
От: Mithun Cy
Дата:
Сообщение: Re: Explain [Analyze] produces parallel scan for select Into table statements.
Следующее
От: Mithun Cy
Дата:
Сообщение: Re: Explain [Analyze] produces parallel scan for select Into table statements.