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