Re: increased max_parallel_workers_per_gather results in fewer workers?

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Philip Semanchuk <philip(at)americanefficient(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: increased max_parallel_workers_per_gather results in fewer workers?
Date: 2020-06-03 21:15:26
Message-ID: 20200603211526.GU30144@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Jun 03, 2020 at 04:04:13PM -0400, Philip Semanchuk wrote:
> Can anyone help me understand why this happens, or where I might look for clues?

What version postgres ?

Can you reproduce if you do:
ALTER SYSTEM SET max_parallel_workers_per_gather=0; SELECT pg_reload_conf();
.. and then within the session do: SET max_parallel_workers_per_gather=12;

I guess you should show an explain analyze, specifically "Workers
Planned/Launched", maybe by linking to explain.depesz.com

--
Justin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Philip Semanchuk 2020-06-03 22:23:57 Re: increased max_parallel_workers_per_gather results in fewer workers?
Previous Message Philip Semanchuk 2020-06-03 20:04:13 increased max_parallel_workers_per_gather results in fewer workers?