>Fra: David Rowley <dgrowleyml@xxxxxxxxx> 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@xxxxxx> 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>); Thank you. That helped. A lot. /Niels
