Number of parallel workers chosen by the optimizer for parallel append
От | Laurenz Albe |
---|---|
Тема | Number of parallel workers chosen by the optimizer for parallel append |
Дата | |
Msg-id | d56c6b20ac6e9d7a69f0d695400bd229c203576c.camel@cybertec.at обсуждение исходный текст |
Ответы |
Re: Number of parallel workers chosen by the optimizer for parallel append
Re: Number of parallel workers chosen by the optimizer for parallel append |
Список | pgsql-general |
I have a partitioned table, each partition has "parallel_workers = 10" set. SET max_parallel_workers_per_gather = 8; SET enable_partitionwise_aggregate = on; EXPLAIN (COSTS OFF) SELECT applicant_name, count(ipc_4) FROM laurenz.z_flat GROUP BY applicant_name; QUERY PLAN -------------------------------------------------- Gather Workers Planned: 4 -> Parallel Append -> HashAggregate Group Key: z_flat_3.applicant_name -> Seq Scan on xyz_4 z_flat_3 -> HashAggregate Group Key: z_flat.applicant_name -> Seq Scan on xyz_1 z_flat [8 more such partition scans] (33 rows) How does the optimizer decide to use 4 parallel workers? No matter what I try, I cannot influence that number. Yours, Laurenz Albe
В списке pgsql-general по дате отправления: