Re: High SYS CPU - need advise

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Vlad <marchenko(at)gmail(dot)com>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: High SYS CPU - need advise
Date: 2012-11-21 16:18:44
Message-ID: CAMkU=1x2JKb3ZW5JRn96uNECiqdW8CYCZA86UznXrSep__oMDQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Nov 21, 2012 at 8:14 AM, Vlad <marchenko(at)gmail(dot)com> wrote:
>
>
> '-M prepared' produces normal results, while '-M simple' results in 40% sys
> cpu. '-M extended' is somewhere in between.
> I'm running it as 60 clients, 2 threads.

2 threads is pretty low for 60 clients. What happens if you increase
-j to either 30 or 60? (What I'm wondering here is if perhaps in this
case it is pgbench which is triggering the scheduling issue)

Also, what happens if you channel pgbench through pgbouncer?

Cheers,

Jeff

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vlad 2012-11-21 16:34:56 Re: High SYS CPU - need advise
Previous Message Vlad 2012-11-21 16:14:11 Re: High SYS CPU - need advise