On 10 March 2017 at 14:05, Ashutosh Bapat <ashutosh.ba...@enterprisedb.com> wrote: >> The need for >> num_workers=-1 will still be there for partial plans, because we need >> to set it to -1 once a worker finishes a plan. >> > > IIRC, we do that so that no other workers are assigned to it when > scanning the array of plans. But with the new scheme we don't need to > scan the non-parallel plans for when assigning plan to workers so -1 > may not be needed. I may be wrong though. >
Still, when a worker finishes a partial subplan , it marks it as -1, so that no new workers pick this, even if there are other workers already executing it. -- Thanks, -Amit Khandekar EnterpriseDB Corporation The Postgres Database Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers