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

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: [GENERAL] core system is getting unresponsive because over 300cpu load
Дата
Msg-id CAOR=d=0DtF0OGcfzSs+2+AtKrdCRF5sk4Vo9UOCCgY-+f9rnBQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] core system is getting unresponsive because over 300 cpu load  (pinker <pinker@onet.eu>)
Ответы Re: core system is getting unresponsive because over 300 cpu load
Список 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 по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: [GENERAL] Restore LargeObjects on different server
Следующее
От: Brian Dunavant
Дата:
Сообщение: Re: [GENERAL] Fwd: [BUGS] BUG #14850: Implement optinal additinalparameter for 'justify' date/time function