Re: [GENERAL] core system is getting unresponsive because over 300cpu load - Mailing list pgsql-general

From Scott Marlowe
Subject Re: [GENERAL] core system is getting unresponsive because over 300cpu load
Date
Msg-id CAOR=d=0DtF0OGcfzSs+2+AtKrdCRF5sk4Vo9UOCCgY-+f9rnBQ@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] core system is getting unresponsive because over 300 cpu load  (pinker <pinker@onet.eu>)
Responses Re: core system is getting unresponsive because over 300 cpu load  (pinker <pinker@onet.eu>)
List pgsql-general
On Tue, Oct 10, 2017 at 4:28 PM, pinker <pinker@onet.eu> wrote:
>
> Yes, it would be much easier if it would be just single query from the top,
> but the most cpu is eaten by the system itself and I'm not sure why.

You are experiencing a context switch storm. The OS is spending so
much time trying to switch between 1,000+ processes it doesn't have
any time left to do much else.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: [GENERAL] Restore LargeObjects on different server
Next
From: Brian Dunavant
Date:
Subject: Re: [GENERAL] Fwd: [BUGS] BUG #14850: Implement optinal additinalparameter for 'justify' date/time function