Parallel queries

YugabyteDB supports the use of PostgreSQL parallel queries. Using parallel queries, the query planner can devise plans that leverage multiple CPUs to answer queries faster.

Currently, YugabyteDB supports parallel queries for colocated tables; support for hash- and range-sharded tables is planned.

To enable and configure parallel queries, set the following configuration parameters.

Parameter	Description	Default
yb_enable_parallel_append	Enables the planner's use of parallel append plans. To enable parallel query, set this to true.	false
yb_parallel_range_rows	The number of rows to plan per parallel worker. To enable parallel query, set this to a value other than 0. (Recommended: 10000)	0
yb_parallel_range_size	Approximate size of parallel range for DocDB relation scans.	1MB

In addition, you can use the following PostgreSQL configuration parameters to configure parallel queries:

• Optimize the number of workers used by the parallel query.
  • max_parallel_workers
  • max_parallel_workers_per_gather
  • max_parallel_maintenance_workers
• Optimize cost of parallel plan to achieve the optimal plan.
  • parallel_setup_cost
  • parallel_tuple_cost
• Enable or disable the query planner's use of hash-join plan types with parallel hash. Has no effect if hash-join plans are not also enabled. The default is on.
  • enable_parallel_hash

For more information, refer to How Parallel Query Works in the PostgreSQL documentation.