Re: Question of Parallel Hash Join on TPC-H Benchmark
От
Zhang Mingli
Тема
Re: Question of Parallel Hash Join on TPC-H Benchmark
Дата
Msg-id
3c7df680-97e6-4f20-ab27-65fb8282f95e@Spark
Ответ на
Re: Question of Parallel Hash Join on TPC-H Benchmark (Tomas Vondra)
Список
Дерево обсуждения
Question of Parallel Hash Join on TPC-H Benchmark Ba Jinsheng <bajinsheng@u.nus.edu>
Re: Question of Parallel Hash Join on TPC-H Benchmark Ba Jinsheng <bajinsheng@u.nus.edu>
Re: Question of Parallel Hash Join on TPC-H Benchmark Tomas Vondra <tomas@vondra.me>
Re: Question of Parallel Hash Join on TPC-H Benchmark Zhang Mingli <zmlpostgres@gmail.com>
Re: Question of Parallel Hash Join on TPC-H Benchmark Ba Jinsheng <bajinsheng@u.nus.edu>
Re: Question of Parallel Hash Join on TPC-H Benchmark Andrei Lepikhov <lepihov@gmail.com>
Re: Question of Parallel Hash Join on TPC-H Benchmark Ba Jinsheng <bajinsheng@u.nus.edu>
Re: Question of Parallel Hash Join on TPC-H Benchmark Andrei Lepikhov <lepihov@gmail.com>
Hi,
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.
Check if enable_parallel_hash = on, an explain(verbose) will show related GUCs.
В списке pgsql-bugs по дате отправления
