Re: Randomly slow queries over TCP, but not on localhost

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Randomly slow queries over TCP, but not on localhost
Дата
Msg-id CAOR=d=1D0wD6-ZEG9oetfnn3Vv_oRJo_3BM0OXhUR9Oza6TLGw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Randomly slow queries over TCP, but not on localhost  (Ramiro Barreca <rbarreca@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Ramiro Barreca
Дата:
Сообщение: Re: Randomly slow queries over TCP, but not on localhost
Следующее
От: Ankur Kaushik
Дата:
Сообщение: Use of PgBouncer