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

Re: Slow application response on lightly loaded server?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow application response on lightly loaded server?
Date: 2012-07-17 21:00:30
Message-ID: CAOR=d=25UuJ+Xo-Twu41vFfw6j+SW3kd8SoFvMjT9DpWJdEH-w@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Well if it suddenly gets faster when connecting by IP, you'll know
where your problem lies.  DNS issues are more common in windows
installs, due to Windows having more interesting ways to misconfigure
dns etc.

On Tue, Jul 17, 2012 at 1:48 PM, Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com> wrote:
> On Tue, Jul 17, 2012 at 2:36 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
> wrote:
>
>
>>
>> Yeah seems reasonable.  The last thing I'd look at is something like
>> improperly configured dns service.  Are you connecting by IP or by
>> host name?
>>
>
> Interesting possibility.  We're currently connecting by host name.  I could
> try temporarily using the IP from one of the servers to see if that helps.
> I'm not familiar enough with DNS services to do any diagnostics other than
> using dig to see where something points.
>
> Thanks for your help, BTW!
>
> __________________________________________________________________________________
> 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
>
>



-- 
To understand recursion, one must first understand recursion.

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2012-07-17 22:56:50
Subject: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)
Previous:From: Mike BlackwellDate: 2012-07-17 19:48:26
Subject: Re: Slow application response on lightly loaded server?

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