| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | 吕晓旭 <lxxstcno1(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "xiaoxu(dot)lv" <xiaoxu(dot)lv(at)qunar(dot)com>, Ying Guo <shrimp0597(at)gmail(dot)com> |
| Subject: | Re: [GENERAL] Fwd: Help！Why CPU Usage and LoadAverage Jump up Suddenly |
| Date: | 2013-12-05 15:44:41 |
| Message-ID: | CAOR=d=2i-U9kU6QE0yFiJawaN2KL_=kg=4+pjwzmqRsdUpcaLg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Dec 5, 2013 at 1:46 AM, 吕晓旭 <lxxstcno1(at)gmail(dot)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 concurrency smoothly 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matt Daw | 2013-12-05 16:05:21 | Re: [GENERAL] Re: [GENERAL] Fwd: Help！Why CPU Usage and LoadAverage Jump up Suddenly |
| Previous Message | Ladislav Lenart | 2013-12-05 14:30:52 | Re: [Q] Update from a table |