Postgres Pro
Downloads
Home   >   mailing lists

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

From Andreas Kretschmer
Subject Re: Parallel Query - Can it be used within functions?
Date
Msg-id 5dc58886-2030-fff8-66d4-d52e439a7586@a-kretschmer.de
Whole thread Raw
In response to Parallel Query - Can it be used within functions?  (Michael Krüger <michael@kruegers.email>)
Responses Re: Parallel Query - Can it be used within functions?
List pgsql-general
Tree view 
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: Michael Krüger
Date:
Subject: Parallel Query - Can it be used within functions?
Next
From: Jeremy Finzel
Date:
Subject: Re: Alter table set logged hanging after writing out all WAL