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

From Peter Eisentraut
Subject Re: System load consideration before spawning parallel workers
Date
Msg-id 295aa4ea-5199-b915-592b-bbb1c0ddf7fe@2ndquadrant.com
Whole thread Raw
In response to Re: System load consideration before spawning parallel workers  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Responses Re: System load consideration before spawning parallel workers  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List pgsql-hackers
On 8/1/16 2:17 AM, Gavin Flower wrote:
> Possibly look how make does it with the '-l' flag?
> 
> '-l 8' don't start more process when load is 8 or greater, works on 
> Linux at least...

The problem with that approach is that it takes about a minute for the
load averages figures to be updated, by which time you have already
thrashed your system.

You can try this out by building PostgreSQL this way.  Please save your
work first, because you might have to hard-reboot your system.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: new gcc warning
Next
From: Pavel Stehule
Date:
Subject: Re: new gcc warning