Hi,
on top of the settings that Sebastian suggested, you can also try disabling the participation of the leader (i.e. the main backend process for your connection) in the distribution of the parallel workload:
SET parallel_leader_participation TO false
Depending on your workload the leader could be saturated if it has to do a share of the workload and aggregate the results of all the workers.
Cheers
Luis |