Re: Question of Parallel Hash Join on TPC-H Benchmark - Mailing list pgsql-bugs

From Zhang Mingli
Subject Re: Question of Parallel Hash Join on TPC-H Benchmark
Date
Msg-id 3c7df680-97e6-4f20-ab27-65fb8282f95e@Spark
Whole thread Raw
In response to Re: Question of Parallel Hash Join on TPC-H Benchmark  (Tomas Vondra <tomas@vondra.me>)
Responses Re: Question of Parallel Hash Join on TPC-H Benchmark
List pgsql-bugs
Hi,


Zhang Mingli
www.hashdata.xyz
On Oct 10, 2024 at 22:41 +0800, Tomas Vondra <tomas@vondra.me>, wrote:

You can try setting parallel_setup_cost and parallel_tuple_cost to 0,
and reducing min_parallel_{table,index}_scan_size. That should force a
parallel plan, and you'll see if parallelism is helpful.
In addition to this, it seems you’r eager a parallel-aware HashJoin.
Check if  enable_parallel_hash = on, an explain(verbose) will show related GUCs.

pgsql-bugs by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Question of Parallel Hash Join on TPC-H Benchmark
Next
From: Ba Jinsheng
Date:
Subject: Re: Question of Parallel Hash Join on TPC-H Benchmark