>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
