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: | Raw Message | Whole Thread | 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 |