public inbox for [email protected]
help / color / mirror / Atom feedHow does max_parallel_workers_per_gather change load averages?
2+ messages / 2 participants
[nested] [flat]
* How does max_parallel_workers_per_gather change load averages?
@ 2017-10-03 19:48 Ben Nachtrieb <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Ben Nachtrieb @ 2017-10-03 19:48 UTC (permalink / raw)
To: pgsql-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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How does max_parallel_workers_per_gather change load averages?
@ 2017-10-03 21:44 David Rowley <[email protected]>
parent: Ben Nachtrieb <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: David Rowley @ 2017-10-03 21:44 UTC (permalink / raw)
To: Ben Nachtrieb <[email protected]>; +Cc: pgsql-performance
On 4 October 2017 at 08:48, Ben Nachtrieb <[email protected]> wrote:
> 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?
Parallel query is not 100% efficient. For example, adding twice the
CPU, in theory, will never double the performance, there's always some
overhead to this. It's really only useful to do on systems with spare
CPU cycles to perform this extra work. You don't seem to have much to
spare, so you may get along better if you disable parallel query.
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-10-03 21:44 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-10-03 19:48 How does max_parallel_workers_per_gather change load averages? Ben Nachtrieb <[email protected]>
2017-10-03 21:44 ` David Rowley <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox