Re: Establishing remote connections is slow

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Establishing remote connections is slow
Дата
Msg-id 4F15517F0200002500044874@gw.wicourts.gov
обсуждение исходный текст
Ответ на Establishing remote connections is slow  (Mindaugas Žakšauskas <mindas@gmail.com>)
Ответы Re: Establishing remote connections is slow  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Mindaugas Žakšauskas<mindas@gmail.com> wrote:

> The essence is that establishing remote connection takes anywhere
> from 10 to 30 seconds. Once connected, the queries are fast

The only time I've seen something similar, there was no reverse DNS
entry to go from IP address to host name.  Adding that corrected the
issue.  I would try that.

If that fixes it, the questions would be whether PostgreSQL is doing
an unnecessary reverse DNS lookup.

-Kevin

В списке pgsql-admin по дате отправления:

Предыдущее
От: Mindaugas Žakšauskas
Дата:
Сообщение: Re: Establishing remote connections is slow
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Establishing remote connections is slow