On Wed, Jun 1, 2016 at 11:45 AM, Petr Jelinek <p...@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
Parallel query uses workers to assist in query execution.
Background tasks use workers during execution.