MIME-Version: 1.0
In-Reply-To: <293b7a8d-9642-6e31-e425-360a6274eaf5@2ndquadrant.com>
References: 
 <CAKFQuwYdW=LLWnzvpzB6D5RB2RpO6u5LcGyvmuR-=CbVzR69xg@mail.gmail.com>
	<293b7a8d-9642-6e31-e425-360a6274eaf5@2ndquadrant.com>
Date: Thu, 12 May 2016 06:24:36 -0700
Message-ID: 
 <CAKFQuwYsb-Wxd9=6xsDxOLWXmWnNL-9C4bmmoVPJPmnGBgsHyg@mail.gmail.com>
Subject: max_worker_processes default not documented
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: "pgsql-docs@postgresql.org" <pgsql-docs@postgresql.org>
Content-Type: multipart/alternative; boundary=001a113cf1525f059f0532a5142c
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

--001a113cf1525f059f0532a5142c
Content-Type: text/plain; charset=UTF-8

On Thursday, May 12, 2016, Peter Eisentraut <
peter.eisentraut@2ndquadrant.com
<javascript:_e(%7B%7D,'cvml','peter.eisentraut@2ndquadrant.com');>> wrote:

> On 5/7/16 11:16 PM, David G. Johnston wrote:
>
>> While this may be in the postgresql.conf it's absence in the docs is made
>> noticeable by the fact both the immediately preceding and subsequent items
>> in the 9.6 docs specify their default values.  Furthermore,
>> max_parallel_degree defaults to 2 but the workers come from the pool sized
>> using max_worker_processes - provoking the very question as to how many is
>> 2 relative to the default pool size.
>>
>
> done
>
>
 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.

David J.

--001a113cf1525f059f0532a5142c
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

On Thursday, May 12, 2016, Peter Eisentraut &lt;<a href=3D"javascript:_e(%7=
B%7D,&#39;cvml&#39;,&#39;peter.eisentraut@2ndquadrant.com&#39;);" target=3D=
"_blank">peter.eisentraut@2ndquadrant.com</a>&gt; wrote:<br><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;pa=
dding-left:1ex">On 5/7/16 11:16 PM, David G. Johnston wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">
While this may be in the postgresql.conf it&#39;s absence in the docs is ma=
de<br>
noticeable by the fact both the immediately preceding and subsequent items<=
br>
in the 9.6 docs specify their default values.=C2=A0 Furthermore,<br>
max_parallel_degree defaults to 2 but the workers come from the pool sized<=
br>
using max_worker_processes - provoking the very question as to how many is<=
br>
2 relative to the default pool size.<br>
</blockquote>
<br>
done<br><br>
</blockquote><div><br></div><div>=C2=A0Thanks.=C2=A0 Now for a related ques=
tion.=C2=A0 Are any of those workers permanently in use?=C2=A0 And what pro=
cesses use them.=C2=A0 I can think of checkpoint writer and autovacuum off =
the top of my head that are potential candidates.</div><div><br></div><div>=
David J.</div>

--001a113cf1525f059f0532a5142c--