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

From Gavin Flower
Subject Re: High SYS CPU - need advise
Date
Msg-id 50AC0D08.4030801@archidevsys.co.nz
Whole thread Raw
In response to Re: High SYS CPU - need advise  (Shaun Thomas <sthomas@optionshouse.com>)
List pgsql-general
On 21/11/12 11:41, Shaun Thomas wrote:
> 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.
>
You'll just have to upgrade to Microsoft!
<Ducks, and runs away _VERY_ quickly!>



Could you not install a later kernel?


Cheers,
Gavin


pgsql-general by date:

Previous
From: Shaun Thomas
Date:
Subject: Re: High SYS CPU - need advise
Next
From: "Kevin Grittner"
Date:
Subject: Re: Experiences with pl/Java