On Fri, Sep 16, 2016 at 6:57 PM, Alex Ignatov <a.igna...@postgrespro.ru> wrote: > No it doesn't. > Paralleling neither sql function nor plpgsql: > Here is example : > > ipdr=> show max_worker_processes ; > max_worker_processes > ---------------------- > 128 > (1 row) > ipdr=> set max_parallel_workers_per_gather to 128; > SET > ipdr=> set force_parallel_mode=on; > SET > ipdr=> set min_parallel_relation_size =0; > SET > ipdr=> set parallel_tuple_cost=0; > SET >
Can you try by setting force_parallel_mode = off;? I think it is sending the whole function execution to worker due to force_parallel_mode. -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
