Re: Randomly slow queries over TCP, but not on localhost - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Randomly slow queries over TCP, but not on localhost
Date
Msg-id CAOR=d=1D0wD6-ZEG9oetfnn3Vv_oRJo_3BM0OXhUR9Oza6TLGw@mail.gmail.com
Whole thread Raw
In response to Re: Randomly slow queries over TCP, but not on localhost  (Ramiro Barreca <rbarreca@gmail.com>)
List pgsql-admin
On Wed, Oct 7, 2015 at 5:18 AM, Ramiro Barreca <rbarreca@gmail.com> wrote:
> I don't think is this case.
> We test this by using the IP address, not the hostname.
>
> What we can see is the extremely low speed of connection in 2 of 10 cases,
> when using a psql at command line with a simple "select 1 from...." inside a
> loop of a shell script FROM THE PG SERVER!!!
>
> If we do the same, but using a pipe connection (no IP address), there is no
> delay.
>

OK from your host, do:

ping clientmachinename

where clientmachinename is the name of your client, then using the IP
you get from that type

host 10.0.0.1

replaceing 10.0.0.1 with the IP you got from the ping command. If that
takes several seconds, you've got a reverse lookup problem.


pgsql-admin by date:

Previous
From: Ramiro Barreca
Date:
Subject: Re: Randomly slow queries over TCP, but not on localhost
Next
From: Ankur Kaushik
Date:
Subject: Use of PgBouncer