Re: pg_connect takes 3.0 seconds

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: pg_connect takes 3.0 seconds
Дата
Msg-id 4B4416A7.1040808@postnewspapers.com.au
обсуждение исходный текст
Ответ на Re: pg_connect takes 3.0 seconds  (Dmitri Girski <mitek17@gmail.com>)
Ответы Re: pg_connect takes 3.0 seconds  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-performance
Dmitri Girski wrote:
> Hi Andy,
>
> I tried  2 connections strings:
> - server name (DB1),  which is listed in all machines hosts files.
> - ip address.
>
> There is no difference in both methods, still I have 5-7 pg_connects which
> last around 3 seconds.

Don't rule out reverse DNS issues (such as a negative cache entry
expiring and being re-checked), packet loss, nss issues on the server
related to NIS, LDAP etc user directories, and so on.

Wireshark is your friend.

--
Craig Ringer

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: pg_connect takes 3.0 seconds
Следующее
От: Matthew Wakeling
Дата:
Сообщение: Re: pg_connect takes 3.0 seconds