Re: Rename max_parallel_degree? - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Rename max_parallel_degree?
Date
Msg-id CAKFQuwaky0NtdjOkU7mp1n=-WREcL6n2PKT28cTQzV7gNPWjbQ@mail.gmail.com
Whole thread Raw
In response to Re: Rename max_parallel_degree?  (Petr Jelinek <petr@2ndquadrant.com>)
Responses Re: Rename max_parallel_degree?  (Petr Jelinek <petr@2ndquadrant.com>)
List pgsql-hackers
On Wed, Jun 1, 2016 at 11:45 AM, Petr Jelinek <petr@2ndquadrant.com> wrote:
That GUC also controls worker processes that are started by extensions, not just ones that parallel query starts. This is btw one thing I don't like at all about how the current limits work, the parallel query will fight for workers with extensions because they share the same limit.

​Given that this models reality the GUC is doing its job.  Now, maybe we need additional knobs to give the end-user the ability to influence how those fights will turn out.

But as far as a high-level setting goes max_worker_processes seems to fit the bill - and apparently fits within our existing cluster options naming convention.

Parallel query uses workers to assist in query execution.
Background tasks use workers during execution.
​Others.....​

David J.

pgsql-hackers by date:

Previous
From: Petr Jelinek
Date:
Subject: Re: Rename max_parallel_degree?
Next
From: Jim Nasby
Date:
Subject: Re: JSON[B] arrays are second-class citizens