public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ben Nachtrieb <[email protected]>
To: [email protected] <[email protected]>
Subject: How does max_parallel_workers_per_gather change load averages?
Date: Tue, 3 Oct 2017 19:48:39 +0000
Message-ID: <BN6PR1301MB2212820B17792E0E52802EC0D4720@BN6PR1301MB2212.namprd13.prod.outlook.com> (raw)
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-performance>
Hello,
This is my first question on this list.
How does max_parallel_workers_per_gather change Linux server load averages?
I have 2 cores and my max_parallel_workers_per_gather = 2 and max_worker_processes = 8, but my load averages are between 8 and 5 with scheduled at 1/189 to 5/195. Are these so high because I increased max_parallel_workers_per_gather? My understanding is that if my load averages are greater than my number of cores the system is overloaded. Should I think about it differently once I increase max_parallel_workers_per_gather? How should I think about it?
I am using postgres 9.6.
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: How does max_parallel_workers_per_gather change load averages?
In-Reply-To: <BN6PR1301MB2212820B17792E0E52802EC0D4720@BN6PR1301MB2212.namprd13.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox