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

From Shaun Thomas
Subject Re: High SYS CPU - need advise
Date
Msg-id 50ABABFA.9070509@optionshouse.com
Whole thread Raw
In response to Re: High SYS CPU - need advise  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: High SYS CPU - need advise  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
On 11/20/2012 10:03 AM, Merlin Moncure wrote:

> Shared buffer manipulation changing contention is suggesting you're
> running into free list lock issues.  How many active backends/cores?

Oh, the reason I wanted to point it out was that we see a lot more than
CPU contention with higher shared_buffer settings. The scheduler starts
aggressively clearing out the file cache *and* freeing memory, driving
load way higher than it should be. That doesn't result in a very high
iowait, but all that page swapping sure isn't free.

--
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: Merlin Moncure
Date:
Subject: Re: High SYS CPU - need advise
Next
From: Merlin Moncure
Date:
Subject: Re: High SYS CPU - need advise