Re: pg_connect takes 3.0 seconds

Поиск
Список
Период
Сортировка
От Craig James
Тема Re: pg_connect takes 3.0 seconds
Дата
Msg-id 4B44D6F0.3090107@emolecules.com
обсуждение исходный текст
Ответ на Re: pg_connect takes 3.0 seconds  (Dave Crooke <dcrooke@gmail.com>)
Список pgsql-performance
Dave Crooke wrote:
> The fact that the delays are clustered at (3 + 0.2 n) seconds, rather
> than a distributed range, strongly indicates a timeout and not
> (directly) a resource issue.
>
> 3 seconds is too fast for a timeout on almost any DNS operation, unless
> it has been modified, so I'd suspect it's the TCP layer, e.g. perhaps
> the SYN packet goes awol and it has to retry.
>
> I'd second the vote for investigation with a packet sniffing tool
> (Wireshark, tcpdump, etc)

If you have a PC (Windows), pingplotter is a remarkable and simple tool to use that quickly identifies problems, and
givesresults that are convincing when you show them to your network admin.  Wireshark and tcpdump have a pretty steep
learningcurve and are overkill if your problem is simple. 

Craig

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

Предыдущее
От: Dave Crooke
Дата:
Сообщение: Re: pg_connect takes 3.0 seconds
Следующее
От: Jesper Krogh
Дата:
Сообщение: Digesting explain analyze