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

From Shaun Thomas
Subject Re: High SYS CPU - need advise
Date
Msg-id 50AB9B7F.1010306@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/16/2012 02:31 PM, Merlin Moncure wrote:

> no single thing really stands out -- contention is all over the place.
> lwlock, pinbuffer, dynahash (especially).  I am again suspicious of
> bad scheduler interaction.  any chance we can fire up pgbouncer?

Just want to throw it out there, but we've been having really bad luck
with the scheduler recently. But only when we use 8GB (on our 72GB
system) for shared_buffers. Cut that down to 4GB, and everything is fine
and dandy.

I think the kernel devs have added in some overzealous scheduler code on us.


--
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: r d
Date:
Subject: Request for help setting up source tree
Next
From: Merlin Moncure
Date:
Subject: Re: High SYS CPU - need advise