| From: | Teja Jakkidi <teja(dot)jakkidi05(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Workers in Postgres |
| Date: | 2022-07-26 00:20:08 |
| Message-ID: | BBAD8621-02B5-4978-BC53-EC8759A7B55B@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2022-07-26 02:37:10 | Re: Workers in Postgres |
| Previous Message | Nikhil Shetty | 2022-07-23 06:13:40 | Re: Get hot_standby_feedback messages |