public inbox for [email protected]
help / color / mirror / Atom feedRe: Default values in the docs
2+ messages / 2 participants
[nested] [flat]
* Re: Default values in the docs
@ 2026-02-27 15:47 Adrian Klaver <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Adrian Klaver @ 2026-02-27 15:47 UTC (permalink / raw)
To: Igor Korot <[email protected]>; pgsql-generallists.postgresql.org <[email protected]>
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-CREATETABLE-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.
The settings that cover items in postgresql.conf have defaults shown here:
https://www.postgresql.org/docs/current/runtime-config.html
As example the default for:
vacuum_truncate, toast.vacuum_truncate
Per-table value for vacuum_truncate parameter.
can be found here:
https://www.postgresql.org/docs/current/runtime-config-vacuum.html#GUC-VACUUM-TRUNCATE
>
> Is this an oversight or intentional?
>
> Thank you.
>
>
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Default values in the docs
@ 2026-02-27 15:58 David G. Johnston <[email protected]>
parent: Adrian Klaver <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: David G. Johnston @ 2026-02-27 15:58 UTC (permalink / raw)
To: Adrian Klaver <[email protected]>; +Cc: Igor Korot <[email protected]>; pgsql-generallists.postgresql.org <[email protected]>
Trimming excess content...
On Fri, Feb 27, 2026 at 8:48 AM Adrian Klaver <[email protected]>
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-CREATETABLE-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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2026-02-27 15:58 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-02-27 15:47 Re: Default values in the docs Adrian Klaver <[email protected]>
2026-02-27 15:58 ` David G. Johnston <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox