how does PostgreSQL determine how many parallel processes to start

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема how does PostgreSQL determine how many parallel processes to start
Дата
Msg-id CAKoxK+61MVdABb2eQ_VLfvRT0hEX12dOkx6Bz9orS5VQ--UvVQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: how does PostgreSQL determine how many parallel processes to start  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general
Hi all,
I know that parallel processes can be limited by
max_parallel_workers_per_gather and max_parallel_workers, as well as
the condition to consider a parallel plan is min_table_scan_size (and
index). But I would like to understand, once a table has been
considered for a parallel plan, and there is room for other workers,
how will PostgreSQL decide to start another process?

Thanks,
Luca



В списке pgsql-general по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Syntax checking DO blocks and ALTER TABLE statements?
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: how does PostgreSQL determine how many parallel processes to start