| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | rihad <rihad(at)mail(dot)ru>, hjp-pgsql(at)hjp(dot)at |
| Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Gigantic load average spikes |
| Date: | 2019-04-01 14:17:48 |
| Message-ID: | 1c9f287c-701c-8c62-dee2-1cc38721ef3d@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2019-04-01 14:22:30 | Re: Table Export & Import |
| Previous Message | Alvaro Herrera | 2019-04-01 14:07:27 | Re: CVE-2019-9193 about COPY FROM/TO PROGRAM |