Re: High SYS CPU - need advise

Поиск
Список
Период
Сортировка
От Shaun Thomas
Тема Re: High SYS CPU - need advise
Дата
Msg-id 50AC0711.6090201@optionshouse.com
обсуждение исходный текст
Ответ на Re: High SYS CPU - need advise  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: High SYS CPU - need advise  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Список pgsql-general
On 11/20/2012 04:35 PM, Jeff Janes wrote:

> Atomic update commit failure in the meatware :)

Ha.

What's actually funny is that one of the affected machines started
*swapping* earlier today. With 15GB free, and 12GB of inactive cache,
and vm.swappiness set to 0, it somehow decided there was enough memory
pressure to push 1.5GB of *something* into swap.

Frankly, the kernel we're using is clearly deranged. There's really no
other way to explain this. But we were blaming various elements of PG
for several weeks following our upgrade. After further examination, our
query profile isn't any different, and the load spikes were effectively
random.

All I can say is... be wary of the 3.2 kernel. It's... unique.

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-444-8534
sthomas@optionshouse.com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email


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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: High SYS CPU - need advise
Следующее
От: Gavin Flower
Дата:
Сообщение: Re: High SYS CPU - need advise