Re: [PERFORM] pg_connect takes 3.0 seconds

2010-01-09 Thread Dmitri Girski
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

2010-01-06 Thread Dmitri Girski
, Jan 5, 2010 at 1: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

Re: [PERFORM] pg_connect takes 3.0 seconds

2010-01-05 Thread Dmitri Girski
a...@squeakycode.net wrote: 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 takes exactly 3.0 seconds. The usual connection

Re: [PERFORM] pg_connect takes 3.0 seconds

2010-01-05 Thread Dmitri Girski
(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

Re: [PERFORM] pg_connect takes 3.0 seconds

2010-01-05 Thread Dmitri Girski
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 a...@squeakycode.net wrote: On 1/4/2010 8:12 PM, Dmitri Girski wrote: Hi everybody, I

Re: [PERFORM] pg_connect takes 3.0 seconds

2010-01-05 Thread Dmitri Girski
( 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 t...@sss.pgh.pa.us wrote: Dmitri Girski mite...@gmail.com writes: I am running a PostgreSQL server 8.3.5

Re: [PERFORM] pg_connect takes 3.0 seconds

2010-01-05 Thread Dmitri Girski
: Dmitri Girski wrote: 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

[PERFORM] pg_connect takes 3.0 seconds

2010-01-04 Thread Dmitri Girski
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