Re: pg_connect takes 3.0 seconds

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_connect takes 3.0 seconds
Дата
Msg-id 28249.1262668449@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_connect takes 3.0 seconds  (Dmitri Girski <mitek17@gmail.com>)
Ответы Re: pg_connect takes 3.0 seconds  (Dmitri Girski <mitek17@gmail.com>)
Список pgsql-performance
Dmitri Girski <mitek17@gmail.com> writes:
> I am running a PostgreSQL server 8.3.5 with a pretty much standard config.

> The web application server which runs Apache 1.3/PHP2.9  has an intermittent
> problem:
> pg_connect takes exactly 3.0 seconds. The usual connection time is 0.0045.
> The long request happens at approximate rate 1:100.

Sounds a lot like a dropped-packets problem.  The exact timing would be
explained if that is the retransmit timeout in your client-side TCP
stack.  If that's what it is, you need some network engineers, not us
database geeks ...

            regards, tom lane

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

Предыдущее
От: Craig James
Дата:
Сообщение: Re: DB is slow until DB is reloaded
Следующее
От: Tom Lane
Дата:
Сообщение: Re: forced sequential scan when condition has current_user