public inbox for [email protected]
help / color / mirror / Atom feedFrom: Peter Eisentraut <[email protected]>
To: David G. Johnston <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: max_worker_processes default not documented
Date: Tue, 2 Aug 2016 13:57:15 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAKFQuwYsb-Wxd9=6xsDxOLWXmWnNL-9C4bmmoVPJPmnGBgsHyg@mail.gmail.com>
References: <CAKFQuwYdW=LLWnzvpzB6D5RB2RpO6u5LcGyvmuR-=CbVzR69xg@mail.gmail.com>
<[email protected]>
<CAKFQuwYsb-Wxd9=6xsDxOLWXmWnNL-9C4bmmoVPJPmnGBgsHyg@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>
On 5/12/16 9:24 AM, David G. Johnston wrote:
> Thanks. Now for a related question. Are any of those workers
> permanently in use? And what processes use them. I can think of
> checkpoint writer and autovacuum off the top of my head that are
> potential candidates.
max_worker_processes only controls "background workers". The other
facilities you mention don't count as such (confusingly perhaps).
Before 9.6, the only background workers were from extensions. In 9.6,
the parallel workers also use the background worker facilities and count
against max_worker_processes.
More documentation is possible here. I think maybe a section somewhere
that summarizes all the parallel-related settings. And also something
in the release notes noting that max_worker_processes is now also used
by built-in facilities, so you should increase it if you have previously
adjusted it for something.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
view thread (4+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: max_worker_processes default not documented
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox