Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Scott MarloweDate: 2012-07-17 17:49:51
Subject: Re: Slow application response on lightly loaded server?
Previous:From: Claudio FreireDate: 2012-07-17 16:55:49
Subject: Re: very very slow inserts into very large table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group