Re: [GENERAL] Fwd: Help!Why CPU Usage and LoadAverage Jump up Suddenly - Mailing list pgsql-general

From Scott Marlowe
Subject Re: [GENERAL] Fwd: Help!Why CPU Usage and LoadAverage Jump up Suddenly
Date
Msg-id CAOR=d=2i-U9kU6QE0yFiJawaN2KL_=kg=4+pjwzmqRsdUpcaLg@mail.gmail.com
Whole thread Raw
In response to Fwd: Help!Why CPU Usage and LoadAverage Jump up Suddenly  (吕晓旭 <lxxstcno1@gmail.com>)
Responses Re: [GENERAL] Re: [GENERAL] Fwd: Help!Why CPU Usage and LoadAverage Jump up Suddenly  (Matt Daw <matt@shotgunsoftware.com>)
List pgsql-general
On Thu, Dec 5, 2013 at 1:46 AM, 吕晓旭 <lxxstcno1@gmail.com> wrote:
>
>
>
> Hi, all
>     We find so weird problem on our productive PostgreSQL system. And I don't know how could I do to resolve this
problem.
>     We deployed PostgreSQL 9.2.4 on two system environments,  and the performances between them are absolutely
different.one of them it's perfect, and the other one lets me down, CPU Usage and LoadAverage Jumped up Suddenly when
concurrencysmoothly rising up, simultaneously, average response time become unacceptable. 
>     Anyone, who could give me some advice?
>
>     The parameters of system environment and PotgreSQL listed below:

Have you tried  monitoring your IO subsystem when this happens? I'd be
interested in iostat, vmstat, iotop, and so on to see what the IO
looks like.


pgsql-general by date:

Previous
From: Ladislav Lenart
Date:
Subject: Re: [Q] Update from a table
Next
From: Matt Daw
Date:
Subject: Re: [GENERAL] Re: [GENERAL] Fwd: Help!Why CPU Usage and LoadAverage Jump up Suddenly