| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Dmitri Girski <mitek17(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: pg_connect takes 3.0 seconds |
| Date: | 2010-01-06 04:39:40 |
| Message-ID: | dcc563d11001052039p5044b13ya2be8f35bbd3e81d@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, Jan 5, 2010 at 8:49 PM, Dmitri Girski <mitek17(at)gmail(dot)com> wrote:
> 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.
Have you looked at the various logs inn /var/log on both machines?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2010-01-06 04:50:47 | Re: pg_connect takes 3.0 seconds |
| Previous Message | Dmitri Girski | 2010-01-06 04:26:30 | Re: pg_connect takes 3.0 seconds |