Re: System load consideration before spawning parallel workers - Mailing list pgsql-hackers

From Tom Lane
Subject Re: System load consideration before spawning parallel workers
Date
Msg-id 5239.1472761122@sss.pgh.pa.us
Whole thread Raw
In response to Re: System load consideration before spawning parallel workers  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List pgsql-hackers
Gavin Flower <GavinFlower@archidevsys.co.nz> writes:
> On 02/09/16 04:44, Peter Eisentraut wrote:
>> You can try this out by building PostgreSQL this way.  Please save your
>> work first, because you might have to hard-reboot your system.

> Hmm...  I've built several versions of pg this way, without any obvious 
> problems!

I'm a little skeptical of that too.  However, I'd note that with a "make"
you're not likely to care, or possibly even notice, if the thing does
something like go completely to sleep for a little while, or if some
sub-jobs proceed well while others do not.  The fact that "-l 8" works
okay for make doesn't necessarily translate to more-interactive use cases.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Fabrízio de Royes Mello
Date:
Subject: CommitFest 2016-09
Next
From: Simon Riggs
Date:
Subject: Re: LOCK TABLE .. DEFERRABLE