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 18:10:31
Message-ID: CANPAkgsBcq_RHNmSU5-6aSndUnDOEnitViMHdYSVkrsU4j8LBw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
I'm wondering about that.  However, the database server and the server
doing the bulk loads are on the same subnet.  Traceroute shows only a
single hop.  Traceroute and ping both show reply times in the area of .25 -
.50 ms or so.  Is that reasonable?

__________________________________________________________________________________
*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/>
* <Mike(dot)Blackwell(at)rrd(dot)com>*


On Tue, Jul 17, 2012 at 12:49 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:

> On Tue, Jul 17, 2012 at 11:37 AM, Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>
> wrote:
> >
> > 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.
>
> Yep it all looks good to me.  Are you sure you're not getting network
> lag or something like that?
>

In response to

Responses

pgsql-performance by date

Next:From: Scott MarloweDate: 2012-07-17 19:36:19
Subject: Re: Slow application response on lightly loaded server?
Previous:From: Scott MarloweDate: 2012-07-17 17:49:51
Subject: Re: Slow application response on lightly loaded server?

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