Re: pg_connect takes 3.0 seconds

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Tom,

The timing is around 3.0 seconds
Time=3.0037 
Time=3.4038 
Time=3.0038 
Time=3.004  
Time=3.2037 
Time=3.0039 
Time=3.0034 
Time=3.0034 
Time=3.2039 
Time=3.0044 
Time=3.8044 
Time=3.2034 

I don't think that it could relate to DNS problem as I tried 2 methods which does not use name resolution ( 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 <tgl@xxxxxxxxxxxxx> wrote:
Dmitri Girski <mitek17@xxxxxxxxx> 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



--
@Gmail

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux