Re: cpu-intensive immutable function and parallel scan

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: cpu-intensive immutable function and parallel scan
Дата
Msg-id CAApHDvrBHyx=1kng+QbcN7B=nbn8ZbxN0gvK35gXaea7sSFpiA@mail.gmail.com
обсуждение исходный текст
Ответ на cpu-intensive immutable function and parallel scan  (Niels Jespersen <NJN@dst.dk>)
Ответы Re: cpu-intensive immutable function and parallel scan
SV: cpu-intensive immutable function and parallel scan
Список pgsql-general
Дерево обсуждения 
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 something high enough.
You can then do:

alter table t1 set (parallel_workers = <number of workers>);

David

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

Предыдущее
От: Niels Jespersen
Дата:
Сообщение: cpu-intensive immutable function and parallel scan
Следующее
От: Mike Yeap
Дата:
Сообщение: Postgres PANIC when it could not open file in pg_logical/snapshots directory