Re: Gigantic load average spikes - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Gigantic load average spikes
Date
Msg-id 1c9f287c-701c-8c62-dee2-1cc38721ef3d@aklaver.com
Whole thread Raw
In response to Re: Gigantic load average spikes  (rihad <rihad@mail.ru>)
Responses Re: Gigantic load average spikes
List pgsql-general
On 3/31/19 10:08 PM, rihad wrote:
>> What exactly do you mean by "running processes"? I don't think I've ever
>> seen a Unix with only 1 to 3 running processes in total, so you are
>> probably referring to processes in a certain state. Runnable (R)?
>> Uninterruptible sleep (D)? Both? Something else?
> 
> Just that, 250-300 running processes in top shown for a second. 250-300 
> is the number of postgres worker processes used, but normally only 1-3 
> of them are running according to top. At times of load FreeBSD (?) 

So what are the process titles?

> schedules all of them to run. This doesn't really put the machine on its 
> knees, it just impacts load avg.
> 
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: CVE-2019-9193 about COPY FROM/TO PROGRAM
Next
From: Adrian Klaver
Date:
Subject: Re: Table Export & Import