Parallel execution and prepared statements

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Parallel execution and prepared statements
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B5397E86F@ntex2010i.host.magwien.gv.at
обсуждение исходный текст
Ответы Re: Parallel execution and prepared statements
Re: Parallel execution and prepared statements
Список pgsql-hackers
Tobias Bussmann has discovered an oddity with prepared statements.

Parallel scan is used with prepared statements, but only if they have
been created with protocol V3 "Parse".
If a prepared statement has been prepared with the SQL statement PREPARE,
it will never use a parallel scan.

I guess that is an oversight in commit 57a6a72b, right?
PrepareQuery in commands/prepare.c should call CompleteCachedPlan
with cursor options CURSOR_OPT_PARALLEL_OK, just like
exec_prepare_message in tcop/postgres.c does.

The attached patch fixes the problem for me.

Yours,
Laurenz Albe

Вложения

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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: Danger of automatic connection reset in psql
Следующее
От: Corey Huinker
Дата:
Сообщение: Re: proposal: psql \setfileref