Workers in Postgres - Mailing list pgsql-admin

From Teja Jakkidi
Subject Workers in Postgres
Date
Msg-id BBAD8621-02B5-4978-BC53-EC8759A7B55B@gmail.com
Whole thread Raw
Responses Re: Workers in Postgres
Re: Workers in Postgres
List 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
thedb?  
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.


pgsql-admin by date:

Previous
From: Nikhil Shetty
Date:
Subject: Re: Get hot_standby_feedback messages
Next
From: "David G. Johnston"
Date:
Subject: Re: Workers in Postgres