SV: cpu-intensive immutable function and parallel scan

Поиск
Список
Период
Сортировка
От Niels Jespersen
Тема SV: cpu-intensive immutable function and parallel scan
Дата
Msg-id 90e5e03eeb1c4eb8946e8ac1556c0ab4@dst.dk
обсуждение исходный текст
Ответ на Re: cpu-intensive immutable function and parallel scan  (David Rowley <dgrowleyml@gmail.com>)
Список pgsql-general
>Fra: David Rowley <dgrowleyml@gmail.com> Sendt: 22. juni 2021 09:10
>Emne: Re: cpu-intensive immutable function and parallel scan
>On Tue, 22 Jun 2021 at 19:06, Niels Jespersen <NJN@dst.dk> wrote:

>> I think I could achieve some speedup by parallelizing further, distributing the cpu-work among additional workers.
But,how do I achive that best?
 
>You'll want to ensure max_parallel_workers_per_gather is set high enough and you have max_parallel_workers set to
somethinghigh enough.
 
>You can then do:
>alter table t1 set (parallel_workers = <number of workers>);

Thank you. That helped. A lot. 
/Niels

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

Предыдущее
От: "Rhys A.D. Stewart"
Дата:
Сообщение: Exclusion constraint with custom operator not working as expected
Следующее
От: Darafei "Komяpa" Praliaskouski
Дата:
Сообщение: Re: [postgis-users] Exclusion constraint with custom operator not working as expected