Re: [COMMITTERS] pgsql: Add max_parallel_workers GUC. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [COMMITTERS] pgsql: Add max_parallel_workers GUC.
Date
Msg-id 989.1480718711@sss.pgh.pa.us
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Add max_parallel_workers GUC.  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: [COMMITTERS] pgsql: Add max_parallel_workers GUC.
List pgsql-hackers
Jim Nasby <Jim.Nasby@BlueTreble.com> writes:
> On 12/2/16 2:34 PM, Robert Haas wrote:
>> Signs point to "no".  It seemed like a good idea to leave some daylight between max_parallel_workers and
max_worker_processes,but evidently this wasn't the way to get there. Or else we should just give up on that thought. 

> Could the defaults be scaled based on max_connections, with a max on the
> default?

Might work.  We've had very bad luck with GUC variables with
interdependent defaults, but maybe the user-visible knob could be a
percentage of max_connections or something like that.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: [COMMITTERS] pgsql: Add max_parallel_workers GUC.
Next
From: Jim Nasby
Date:
Subject: Re: PSQL commands: \quit_if, \quit_unless