Re: [PERFORM] pg_connect takes 3.0 seconds

Thanks for advice, Dave! This saga ended in an unexpected way: the firewall died. Since the replacement firewall installed I have not seen any 3 seconds connects. Well, there was no real load so far, but I will keep checking. Thanks to everyone replied, it was very helpful. Cheers, Dmitri.

Re: [PERFORM] pg_connect takes 3.0 seconds

n Tue, Jan 5, 2010 at 1:12 PM, Dmitri Girski 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.

Re: [PERFORM] pg_connect takes 3.0 seconds

RT TRANSACTION [2010-01-06 14:58:18 EST] idleLOCATION: exec_simple_query, postgres.c:845 [2010-01-06 14:58:18 EST] START TRANSACTIONLOG: 0: duration: 0.050 ms === Cheers, Dmitri. On Tue, Jan 5, 2010 at 2:01 PM, Greg Smith wrote: &g

Re: [PERFORM] pg_connect takes 3.0 seconds

ution ( hosts file & ip address) I will definitely seek the help from network geeks and I will check all TCP stack settings. Thank you! Cheers, Dmitri. On Tue, Jan 5, 2010 at 4:14 PM, Tom Lane wrote: > Dmitri Girski writes: > > I am running a PostgreSQL server 8.3.5 with a pretty much

Re: [PERFORM] pg_connect takes 3.0 seconds

Thank you for reply , Andy! I tried both cases: server name which is listed in hosts file and ip address ( 192.168.2.2) - no difference so far. Cheers, Dmitri. On Wed, Jan 6, 2010 at 2:03 AM, Andy Colson wrote: > On 1/4/2010 8:12 PM, Dmitri Girski wrote: > >> Hi everybody, >&g

Re: [PERFORM] pg_connect takes 3.0 seconds

> 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" wrote: > > > Hi everybody, > > &

Re: [PERFORM] pg_connect takes 3.0 seconds

On 1/4/2010 8:12 PM, Dmitri Girski 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 take

[PERFORM] pg_connect takes 3.0 seconds

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: