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

From Vlad
Subject Re: High SYS CPU - need advise
Date
Msg-id CAKeSUqUsx69dNxQZWSpT+XHm=oRWafKhmgrz+D3cTNhSP46rGQ@mail.gmail.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
what would pgbouncer do in my case? Number of connections will decrease, but number of active clients won't be smaller. As I understand the latter ones are that important.

-- Vlad


On Fri, Nov 16, 2012 at 2:31 PM, Merlin Moncure <mmoncure@gmail.com> wrote:

first thoughts:
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?

merlin

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: High SYS CPU - need advise
Next
From: "JulAkmad, Julpikar"
Date:
Subject: Re: [SOLVED] WINDOWS : PostgreSQL 8.4 Server Start Error