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 CAKFQuwaiF1bbuy7X3RKkXu6GG7EaAchS5kWL1W3dBdzqojnuwQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Retrieve results in PostgreSQL stored procedure allowing query parallelism  (Joan Pujol <joanpujol@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Tue, Nov 21, 2023 at 11:31 AM Joan Pujol <joanpujol@gmail.com> wrote:
If I try to do something like:
EXECUTE SELECT INTO ARRAY_AGG(t.*) INTO result_records
Would internally use cursors too and have the same restrictions?


Producing a single row single column result and then storing it into a variable should leverage parallelism if the query is amenable to it.

David J.

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

Предыдущее
От: CG
Дата:
Сообщение: Removing oids with pg_repack
Следующее
От: "Johnson, Bruce E - (bjohnson)"
Дата:
Сообщение: Connection fails on one system in a address range allowed to connect