Re: Parallel execution and prepared statements

Поиск
Список
Период
Сортировка
От Tobias Bussmann
Тема Re: Parallel execution and prepared statements
Дата
Msg-id 7D26B024-2E67-49DA-AD92-4CA0C18E59F7@gmx.net
обсуждение исходный текст
Ответ на Re: Parallel execution and prepared statements  (Tobias Bussmann <t.bussmann@gmx.net>)
Ответы Re: Parallel execution and prepared statements
Re: Parallel execution and prepared statements
Список pgsql-hackers
As the patch in [1] targeting the execution of the plan in ExecutePlan depending on the destination was declined, I
hackedaround a bit to find another way to use parallel mode with SQL prepared statements while disabling the parallel
executionin case of an non read-only execution. For this I used the already present test for an existing intoClause in
ExecuteQueryto set the parallelModeNeeded flag of the prepared statement. This results in a non parallel execution of
theparallel plan, as we see with a non-zero fetch count used with the extended query protocol. Despite this patch seem
towork in my tests, I'm by no means confident this being a proper way of handling the situation in question. 

Best
Tobias

[1] https://www.postgresql.org/message-id/CAA4eK1KxiYm8F9Pe9xvqzoZocK43w%3DTRPUNHZpe_iOjF%3Dr%2B_Vw%40mail.gmail.com





Вложения

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Password identifiers, protocol aging and SCRAM protocol
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Something is broken about connection startup