Re: High SYS CPU - need advise

it's session mode and the pool size is 1200 (cause I need to grantee that
in the worst case we have enough slots for all possible clients), however
even at the times preceding high-cpu-sys-stall, the number postmasters are
like 15-20. When stall happens, it starts to raise but that's the result of
DB not answering in timely manner.

as far as data - yes, I can probably clean up names and provide some data
with same queries, though - we are not able to cause a stall just with
those queries & pgbench; we are able to make the situation worse and stall
much likely when it's overlapped with regular queries coming from our app.

-- Vlad

On Wed, Nov 21, 2012 at 10:45 AM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:

> On Wed, Nov 21, 2012 at 10:43 AM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
> > On Wed, Nov 21, 2012 at 7:29 AM, Vlad Marchenko <marchenko(at)gmail(dot)com>
> wrote:
> >
> >> update on my problem: despite pgbouncer, the problem still occures on my
> >> end.
> >
> > As Merlin asked, how big is the pool? Maybe you are using a large
> > enough pool so as to defeat the purpose of restricting the number of
> > connections.
>
> also, what mode.
>
> merlin
>