| From: | Michael Krüger <michael(at)kruegers(dot)email> |
|---|---|
| To: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Parallel Query - Can it be used within functions? |
| Date: | 2018-02-16 10:42:32 |
| Message-ID: | CACSnzzUg2DcdWxuHrek0f_ffLKoFVQR4pQ3pJvp3gDBFc2v4hg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Dear all,
still same behavior with Postgres 10.2 ...
Just as a reminder that the issue still exists.
Regards,
Michael
Andreas Kretschmer <andreas(at)a-kretschmer(dot)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
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thiemo Kellner | 2018-02-16 12:20:49 | Dynamic PL/pgSQL select query: value association propblem |
| Previous Message | pradeep | 2018-02-16 07:32:58 | Re: postgres started without auto vaccum |