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  (Michael Lewis <mlewis@entrata.com>)
Re: Number of parallel workers chosen by the optimizer for parallel append  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: INSERT Trigger to check for existing records : Does this do what I hope it is doing?
Следующее
От: Mats Julian Olsen
Дата:
Сообщение: postgres_fdw insert extremely slow