Missed parallelism option in plpgsql?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Missed parallelism option in plpgsql?
Date: 2017-12-20 19:26:25
Message-ID: 4334.1513797985@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I happened to notice that while writing this in plpgsql
will consider a parallel plan:

select count(*) into s from tenk1 where ten = x;

writing this will not:

s := count(*) from tenk1 where ten = x;

Is that intentional? Seems to me these cases ought to be
treated the same.

The reason for it is that exec_assign_expr's call of
exec_prepare_plan does not specify CURSOR_OPT_PARALLEL_OK.

regards, tom lane

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message neto brpr 2017-12-20 19:26:53 Re: Cost Model
Previous Message Alvaro Herrera 2017-12-20 19:25:11 Re: Cost Model