Re: pg_connect takes 3.0 seconds

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