Re: increased max_parallel_workers_per_gather results in fewerworkers? - Mailing list pgsql-performance

From Luis Carril
Subject Re: increased max_parallel_workers_per_gather results in fewerworkers?
Date
Msg-id LEXPR01MB1182C770FBB48C33231CD2CAE7890@LEXPR01MB1182.DEUPRD01.PROD.OUTLOOK.DE
Whole thread Raw
In response to Re: increased max_parallel_workers_per_gather results in fewerworkers?  (Sebastian Dressler <sebastian@swarm64.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Sebastian Dressler
Date:
Subject: Re: increased max_parallel_workers_per_gather results in fewerworkers?
Next
From: Tomas Vondra
Date:
Subject: Re: increased max_parallel_workers_per_gather results in fewerworkers?