MIME-Version: 1.0
References: <CA+FnnTwgJeaKOuqqDAPzquHuXngbP779CsEMN+WO5oATQEEaAQ@mail.gmail.com>
 <12ca1b36-1933-4775-954c-90f870fb6dd0@aklaver.com>
In-Reply-To: <12ca1b36-1933-4775-954c-90f870fb6dd0@aklaver.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Fri, 27 Feb 2026 08:58:07 -0700
Message-ID: <CAKFQuwbVYKNPNtYXffbGU9CtJs23O2ZCmC0dSQ7jm5SShouhTQ@mail.gmail.com>
Subject: Re: Default values in the docs
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Igor Korot <ikorot01@gmail.com>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000cfe6e5064bd04f5b"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwbVYKNPNtYXffbGU9CtJs23O2ZCmC0dSQ7jm5SShouhTQ%40mail.gmail.com>
Precedence: bulk

--000000000000cfe6e5064bd04f5b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Trimming excess content...

On Fri, Feb 27, 2026 at 8:48=E2=80=AFAM Adrian Klaver <adrian.klaver@aklave=
r.com>
wrote:

> On 2/26/26 10:43 PM, Igor Korot wrote:
> > Hi, ALL,
> > The page at
> https://www.postgresql.org/docs/current/sql-createtable.html#SQL-CREATETA=
BLE-STORAGE-PARAMETERS
> > does not document the default
> > values for all storage parameters.
>
> The only ones that are not covered from what I see are fillfactor and
> parallel_workers.
>

fillfactor: The fillfactor for a table is a percentage between 10 and 100.
100 (complete packing) is the default.

parallel_workers: If not set, the system will determine a value based on
the relation size.

I don't think including the algorithm for parallel_workers would be
appropriate for the documentation.

Hence, both are indeed "covered".

David J.

--000000000000cfe6e5064bd04f5b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif">Trimming excess content...</div></div>=
<br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=
=3D"gmail_attr">On Fri, Feb 27, 2026 at 8:48=E2=80=AFAM Adrian Klaver &lt;<=
a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@aklaver.com</a>&g=
t; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0p=
x 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On 2/2=
6/26 10:43 PM, Igor Korot wrote:<br>
&gt; Hi, ALL,<br>
&gt; The page at <a href=3D"https://www.postgresql.org/docs/current/sql-cre=
atetable.html#SQL-CREATETABLE-STORAGE-PARAMETERS" rel=3D"noreferrer" target=
=3D"_blank">https://www.postgresql.org/docs/current/sql-createtable.html#SQ=
L-CREATETABLE-STORAGE-PARAMETERS</a><br>
&gt; does not document the default<br>
&gt; values for all storage parameters.<br>
<br>
The only ones that are not covered from what I see are fillfactor and <br>
parallel_workers.<br></blockquote><div><br></div><div class=3D"gmail_defaul=
t" style=3D"font-family:arial,helvetica,sans-serif">fillfactor:=C2=A0The fi=
llfactor for a table is a percentage between 10 and 100. 100 (complete pack=
ing) is the default.</div><div class=3D"gmail_default" style=3D"font-family=
:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_default" style=
=3D"font-family:arial,helvetica,sans-serif">parallel_workers:=C2=A0If not s=
et, the system will determine a value based on the relation size.</div><div=
 class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><=
br></div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,=
sans-serif">I don&#39;t think including the algorithm for parallel_workers =
would be appropriate for the documentation.</div><div class=3D"gmail_defaul=
t" style=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=3D=
"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">Hence, bot=
h are indeed &quot;covered&quot;.</div><div class=3D"gmail_default" style=
=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_d=
efault" style=3D"font-family:arial,helvetica,sans-serif">David J.</div><div=
 class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><=
br></div></div></div>

--000000000000cfe6e5064bd04f5b--