Postgres Pro
Downloads
Home   >   mailing lists

Re: Parallel Query - Can it be used within functions? - Mailing list pgsql-general

From Michael Krüger
Subject Re: Parallel Query - Can it be used within functions?
Date
Msg-id CACSnzzUg2DcdWxuHrek0f_ffLKoFVQR4pQ3pJvp3gDBFc2v4hg@mail.gmail.com
Whole thread Raw
In response to Re: Parallel Query - Can it be used within functions?  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Responses Re: Parallel Query - Can it be used within functions?  (Michael Krüger <michael@kruegers.email>)
List pgsql-general
Tree view
Dear all,

still same behavior with Postgres 10.2 ...

Just as a reminder that the issue still exists.

Regards,
Michael

Andreas Kretschmer <andreas@a-kretschmer.de> schrieb am Di., 6. Feb. 2018 um 08:35 Uhr:
Hi,


Am 06.02.2018 um 08:24 schrieb Michael Krüger:
> create or replace function reports.generic_query(_sql text)
>   RETURNS SETOF record
>   LANGUAGE 'plpgsql'
>   PARALLEL SAFE
>   COST 100

there is an other parameter, parallel_setup_cost, with default = 1000. I
think, you should set this parameter too.

Please keep me informed, it is interessting me.


Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com


pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Database health check/auditing
Next
From: Thiemo Kellner
Date:
Subject: Dynamic PL/pgSQL select query: value association propblem