Redrock Postgres Documentation
Home Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage

IPC - ParallelBitmapScan

Short Description

Waiting for parallel bitmap scan to become initialized.

Additional Information

ParallelBitmapScan is an Inter Process Communication (IPC) wait and is seen when the planner selects a Parallel Bitmap Scan execution path. Scan processes need to be acquired and a dynamic shared memory (DSM) segment created.

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.