Re: core system is getting unresponsive because over 300 cpu load

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: pinker <pinker(at)onet(dot)eu>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: core system is getting unresponsive because over 300 cpu load
Date: 2017-10-12 13:25:47
Message-ID: CAOR=d=0DtF0OGcfzSs+2+AtKrdCRF5sk4Vo9UOCCgY-+f9rnBQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Oct 10, 2017 at 4:28 PM, pinker <pinker(at)onet(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brian Dunavant 2017-10-12 14:37:40 Re: Fwd: [BUGS] BUG #14850: Implement optinal additinal parameter for 'justify' date/time function
Previous Message Laurenz Albe 2017-10-12 12:15:54 Re: Restore LargeObjects on different server