From: Dmitri Girski <mitek17@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: pg_connect takes 3.0 seconds
Date: Wed, 6 Jan 2010 14:49:27 +1100
Message-ID: <daed64561001051949wd1523e3p2675d1289faf638@mail.gmail.com> (raw)
In-Reply-To: <28249.1262668449@sss.pgh.pa.us>
References: <daed64561001041812s602a3098l686f630d6448835f@mail.gmail.com>
<28249.1262668449@sss.pgh.pa.us>
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@sss.pgh.pa.us> wrote:
> 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
>
--
@Gmail
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: mitek17@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: pg_connect takes 3.0 seconds
In-Reply-To: <daed64561001051949wd1523e3p2675d1289faf638@mail.gmail.com>
References: <daed64561001041812s602a3098l686f630d6448835f@mail.gmail.com> <28249.1262668449@sss.pgh.pa.us> <daed64561001051949wd1523e3p2675d1289faf638@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox