From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: kline.christopher@gmail.com
Subject: BUG #18343: Incorrect description in postgresql.conf for max_parallel_workers_per_gather
Date: Wed, 14 Feb 2024 22:11:14 +0000
Message-ID: <18343-3a5e903d1d3692ab@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18343
Logged by: Christopher Kline
Email address: kline.christopher@gmail.com
PostgreSQL version: 14.11
Operating system: Windows 10 x64
Description:
In the default postgresql.conf that is generated, there are the following
lines:
#max_worker_processes = 8 # (change requires restart)
#max_parallel_workers_per_gather = 2 # taken from max_parallel_workers
<<<<<<<<<<<<<<<<<<<<<<<< THIS
#max_parallel_maintenance_workers = 2 # taken from max_parallel_workers
max_parallel_workers = 8 # maximum number of max_worker_processes that
# can be used in parallel operations
it indicates that the default value is taken from whatever
max_parallel_workers is. However, if I start postgresql with those settings
and issue a query of
SELECT setting, unit FROM pg_settings WHERE name =
'max_parallel_workers_per_gather'
the result I get is '2', not '8'.
This leads me to believe that either there is a bug in the code that's not
setting the correct default, or the comment in postgresql.conf is incorrect.
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: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, kline.christopher@gmail.com
Subject: Re: BUG #18343: Incorrect description in postgresql.conf for max_parallel_workers_per_gather
In-Reply-To: <18343-3a5e903d1d3692ab@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox