Re: Slow application response on lightly loaded server?

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

<http://www.rrdonnelley.com/>

In response to

Responses

Browse pgsql-performance by date

  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