Hi Scott, Thank you pointers, I've spoken to the network guy, he will help to monitor connections on the firewall. On the other hand, if I use ip addresses this should not attract any possible issues with DNS, right?
Thanks! Dmitri. On Wed, Jan 6, 2010 at 9:32 AM, Scott Carey <sc...@richrelevance.com> wrote: > Delays that are almost exactly 3 seconds over a network are almost always > some sort of network configuration issue. > > Inside a datacenter, mis-configured load balancers or routers can cause low > level network issues that result in intermittent network delays of exactly > 3 > seconds (a loop in a routing network?). > DNS timeouts are often 3 seconds. > > Not sure if any of the above is it, but this sounds like a network > configuration problem to me. > > On 1/4/10 6:12 PM, "Dmitri Girski" <mite...@gmail.com> wrote: > > > Hi everybody, > > > > 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. > > > > I turned on logs on postgres server side, and there is > nothing suspicious for > > me there. When a connection request comes, it is being served without any > > delay. > > > > Could anyone point me to the direction in which I should investigate this > > problem further? > > Thank you in advance! > > > > > > PS The hardware is: Dell SC1435/4Gb/2x2.0GHz/Gentoo Linux. > > The database & web servers are in the 2 local subnets. > > > > > > Dmitri. > > > > > > -- @Gmail
