From: Teja Jakkidi <teja.jakkidi05@gmail.com>
To: pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Workers in Postgres
Date: Mon, 25 Jul 2022 17:20:08 -0700
Message-ID: <BBAD8621-02B5-4978-BC53-EC8759A7B55B@gmail.com> (raw)
Hello Admin team,
I am new to Postgres and please excuse me if these are silly questions:
1. What is a worker process exactly in Postgres?
2. is max_parallel_workers specific to a session or instance. My max_parallel_workers is set to 8. If it is specific to instance, does it mean at any point of time I can only see 8 parallel processes despite the number of transactions in the db?
3. Does number of worker process have anything to do with active connections to the database.
I have read the documentation but unable to catch up correctly. Any help from you is appreciated.
Thanks,
J. Teja.
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-admin@postgresql.org
Cc: teja.jakkidi05@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Workers in Postgres
In-Reply-To: <BBAD8621-02B5-4978-BC53-EC8759A7B55B@gmail.com>
* 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