On Tue, 22 Jun 2021 at 19:06, Niels Jespersen <NJN(at)dst(dot)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