Postgres Pro
Downloads
Home   >   mailing lists

Re: Retrieve results in PostgreSQL stored procedure allowing query parallelism - Mailing list pgsql-general

From David G. Johnston
Subject Re: Retrieve results in PostgreSQL stored procedure allowing query parallelism
Date
Msg-id CAKFQuwaiF1bbuy7X3RKkXu6GG7EaAchS5kWL1W3dBdzqojnuwQ@mail.gmail.com
Whole thread Raw
In response to Re: Retrieve results in PostgreSQL stored procedure allowing query parallelism  (Joan Pujol <joanpujol@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: CG
Date:
Subject: Removing oids with pg_repack
Next
From: "Johnson, Bruce E - (bjohnson)"
Date:
Subject: Connection fails on one system in a address range allowed to connect