| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | WARNING in parallel index creation. |
| Date: | 2018-03-12 05:15:39 |
| Message-ID: | CAMkU=1xY2LLBf4szkQPEQYnGMdGfcfYMxjfG38mqkcd1rj6ryQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
If i run:
pgbench -i -s30
And then create the function:
CREATE OR REPLACE FUNCTION foobar(text)
RETURNS text
LANGUAGE plperl
IMMUTABLE PARALLEL SAFE STRICT COST 10000
AS $function$
return scalar reverse($_[0]);
$function$;
Then when I create in index, I get a warning:
jjanes=# create index on pgbench_accounts (foobar(filler));
WARNING: cannot set parameters during a parallel operation
WARNING: cannot set parameters during a parallel operation
If I create the index again within the same session, there is no WARNING.
This only occurs if plperl.on_init is set in the postgresql.conf file. It
doesn't seem to matter what it is set to,
even the empty string triggers the warning.
plperl.on_init=''
As far as I can tell the index is created correctly despite the warning.
Cheers,
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | amul sul | 2018-03-12 06:15:54 | Re: [HACKERS] Restrict concurrent update/delete with UPDATE of partition key |
| Previous Message | Ashutosh Bapat | 2018-03-12 05:00:54 | Re: [HACKERS] advanced partition matching algorithm for partition-wise join |