Re: High SYS CPU - need advise - Mailing list pgsql-general

From Shaun Thomas
Subject Re: High SYS CPU - need advise
Date
Msg-id 50AC0711.6090201@optionshouse.com
Whole thread Raw
In response to Re: High SYS CPU - need advise  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: High SYS CPU - need advise  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List 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 by date:

Previous
From: Jeff Janes
Date:
Subject: Re: High SYS CPU - need advise
Next
From: Gavin Flower
Date:
Subject: Re: High SYS CPU - need advise