Redrock Postgres Documentation
Home Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage
  1. Redrock Postgres Documentation
  2. /
  3. Wait Events
  4. /
  5. IPC - ParallelFinish
Edit page

IPC - ParallelFinish

Short Description

Waiting for parallel workers to finish computing.

Additional Information

During parallel execution plans, tasks are allocated to a number of workers. This wait is seen while the background worker processes finish their work.

How to reduce this wait

Parallel queries are excellent at scanning large amounts of data the quickly returning results. Run in isolation or in a considered manner they are a useful tool.

Do not allow concurrent parallel queries from many users to flood system CPU or IO resources.

Adjust max_worker_process , max_parallel_workers and max_parallel_workers_per_gather to control response of your query and overall impact to the system.