On Fri, Sep 27, 2019 at 8:07 PM Jeff Davis <pg...@j-davis.com> wrote: > The current docs for max_parallel_workers start out: > > "Sets the maximum number of workers that the system can support for > parallel operations..." > > In my interpretation, "the system" means the entire cluster, but the > max_parallel_workers setting is PGC_USERSET. That's a bit confusing, > because two different backends can have different settings for "the > maximum number ... the system can support".
Oops. I intended it to mean "the entire cluster." Basically, how many workers out of max_worker_processes are you willing to use for parallel query, as opposed to other things. I agree that PGC_USERSET doesn't make any sense. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company