From: | Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com> |
---|---|
To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Slow application response on lightly loaded server? |
Date: | 2012-07-17 17:37:43 |
Message-ID: | CANPAkguGHV21b2PA7mo4KqR7-Rzis=ESMW_fEXUDCm=RQMt0kw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Tue, Jul 17, 2012 at 11:35 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
wrote:
I'd run vmstat and look for high cs or int numbers (100k and above) to
> see if you're maybe seeing an issue with that. A lot of times a
> "slow" server is just too much process switching. But yeah, the
> graphs you've posted don't seem overly bad.
>
Thanks for the tip. Here's a quick look at those numbers under that same
load. Watching it for a while longer didn't show any spikes. That doesn't
seem to be it, either.
$ vmstat 5
procs -----------memory---------- ---swap-- -----io---- --system--
----cpu----
r b swpd free buff cache si so bi bo in cs us sy id
wa
3 0 11868 34500 16048 3931436 0 0 4 2 0 0 6 2
91 1
2 0 11868 21964 16088 3931396 0 0 0 212 8667 8408 15 3
80 2
0 0 11868 37772 16112 3932152 0 0 2 249 9109 8811 34 2
62 1
2 0 11868 34068 16124 3932400 0 0 1 168 9142 9165 12 3
84 1
1 0 11868 38036 16124 3932920 0 0 8 155 9995 10904 16 4
80 1
1 0 11868 40212 16124 3933440 0 0 0 146 9586 9825 13 3
83 1
__________________________________________________________________________________
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike(dot)Blackwell(at)rrd(dot)com
http://www.rrdonnelley.com
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2012-07-17 17:49:51 | Re: Slow application response on lightly loaded server? |
Previous Message | Claudio Freire | 2012-07-17 16:55:49 | Re: very very slow inserts into very large table |