Re: Occasional giant spikes in CPU load

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Occasional giant spikes in CPU load
Дата
Msg-id 10446.1270685931@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Occasional giant spikes in CPU load  (Craig James <craig_james@emolecules.com>)
Список pgsql-performance
Craig James <craig_james@emolecules.com> writes:
> On 4/7/10 3:36 PM, Joshua D. Drake wrote:
>> To have your CPUs so flooded that they are the cause of an inability to
>> log in is pretty suspect.

> I thought so too, except that I can't login during the flood.  If the CPUs were all doing iowaits, logging in should
beeasy. 

> Greg's suggestion that shared_buffers and work_mem are too big for an 8 GB system fits these symptoms -- if it's
havinga swap storm, login is effectively impossible. 

Yeah, but there is also the question of what's causing all the backends
to try to run at the same time.  Oversubscribed memory could well be the
direct cause of the machine getting driven into the ground, but there's
something else going on here too IMO.

Anyway I concur with the advice to lower shared_buffers, and run fewer
backends if possible, to see if that ameliorates the problem.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: David Rees
Дата:
Сообщение: Re: Occasional giant spikes in CPU load
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Occasional giant spikes in CPU load