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

From rihad
Subject Re: Gigantic load average spikes
Date
Msg-id 18b22010-1e6f-9270-e273-b9803fee1498@mail.ru
Whole thread Raw
In response to Gigantic load average spikes  (rihad <rihad@mail.ru>)
Responses Re: Gigantic load average spikes  (David Rowley <david.rowley@2ndquadrant.com>)
Re: Gigantic load average spikes  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
> 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 (?) 
schedules all of them to run. This doesn't really put the machine on its 
knees, it just impacts load avg.




pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Gigantic load average spikes
Next
From: David Rowley
Date:
Subject: Re: Gigantic load average spikes