| From: | Shaun Thomas <sthomas(at)optionshouse(dot)com> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | Merlin Moncure <mmoncure(at)gmail(dot)com>, Vlad <marchenko(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: High SYS CPU - need advise |
| Date: | 2012-11-20 22:41:21 |
| Message-ID: | 50AC0711.6090201@optionshouse.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)optionshouse(dot)com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2012-11-20 22:52:15 | Re: High SYS CPU - need advise |
| Previous Message | Jeff Janes | 2012-11-20 22:35:46 | Re: High SYS CPU - need advise |