Re: High SYS CPU - need advise

From: Vlad <marchenko(at)gmail(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Jeff Janes <jeff(dot)janes(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-16 21:21:09
Message-ID: CAKeSUqUsx69dNxQZWSpT+XHm=oRWafKhmgrz+D3cTNhSP46rGQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2012-11-16 21:32:35 Re: High SYS CPU - need advise
Previous Message Steven Schlansker 2012-11-16 20:44:51 Re: Noticed something odd with pgbench