Skip to main content

Hash_GrowBuckets_Reinserting

Short Description

A process is waiting for other parallel hash participants to finish inserting tuples into new buckets.

Additional Information

In parallel hash queries, a number of hash tables are used and both sides of the join are split into batches. Within each batch, buckets are used to group tuples. This wait is seen while parallel hash participants finish inserting tuples into new buckets.

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.

PostgreSQL documentation - Parallel Query

PostgreSQL documentation - The Statistics Collector

EDB - Parallel Hash Joins in PostgreSQL Explained

Search online

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.