Re: Retrieve results in PostgreSQL stored procedure allowing query parallelism

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Retrieve results in PostgreSQL stored procedure allowing query parallelism
Дата
Msg-id CAKFQuwaXoR=Rzh+dGRWBxUxuAtriqsfDGdSC=z+OyShAHPzfUQ@mail.gmail.com
обсуждение исходный текст
Ответ на Retrieve results in PostgreSQL stored procedure allowing query parallelism  (Joan Pujol <joanpujol@gmail.com>)
Ответы Re: Retrieve results in PostgreSQL stored procedure allowing query parallelism
Список pgsql-general
Дерево обсуждения
On Tue, Nov 21, 2023, 11:10 Joan Pujol <joanpujol@gmail.com> wrote:
I want to execute an SQL query and process its results inside a stored
procedure without preventing query parallelism. Since I don't want to
prevent query parallelism, cursors can't be used, and I would like to
avoid creating a temporal table.

Is this possible? If so, what is the best way to execute the query,
retrieve all results in memory, and process them inside the stored
procedure?

You must use create table as if you want a result that is both accessible to subsequent statements and uses parallelism to be produced.  There is no saving results into memory - you either save them explicitly or iterate over them and the later prevents parallelism as you've noted.

David J.

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

Предыдущее
От: Joan Pujol
Дата:
Сообщение: Retrieve results in PostgreSQL stored procedure allowing query parallelism
Следующее
От: Joan Pujol
Дата:
Сообщение: Re: Retrieve results in PostgreSQL stored procedure allowing query parallelism