Re: Gigantic load average spikes

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: rihad <rihad(at)mail(dot)ru>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Gigantic load average spikes
Date: 2019-04-01 15:12:15
Message-ID: f924a817-655f-8c02-3803-70256e3b72e2@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 4/1/19 8:06 AM, rihad wrote:
> On 04/01/2019 06:17 PM, Adrian Klaver wrote:
>> 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?
>
> postgres

Have you tried hitting the 'c' key in top to get a fuller description?

>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michel Pelletier 2019-04-01 16:17:26 Re: Table Export & Import
Previous Message Ron 2019-04-01 15:11:38 Re: Table Export & Import