| From: | Poul Møller Hansen <freebsd(at)pbnet(dot)dk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Slow connection to the database |
| Date: | 2005-09-24 19:14:29 |
| Message-ID: | 4335A595.6020805@pbnet.dk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>
> Is it possible that you've got DNS timeouts happening or something
> like that? Though I don't think PG does reverse DNS lookups,
> especially not by default.
>
> Watching the connection process with 'tcpdump' to see where the stall
> happens might be informative.
>
> -Doug
DNS was also my first thought, but the connection isn't logged so why do
reverse lookup and with my clients ip address in /etc/hosts is same.
I have now also tried on a Sun Ultra Sparc running Solaris 10
and an Intel EMT64 running FreeBSD 6-BETA4 with the same discouraging
result. On the FreeBSD I have tried both compiling by hand and from ports.
All servers where it isn't working properly have in common that it
is PgSQL ver. 8.0.3 compiled with gcc ver. 3.4.4 running on 64-bits
cpu's
It's working well on an old K6-II running FreeBSD 4.11, PgSQL 8.03
compiled with gcc 2.95.4
Poul
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-09-24 19:49:45 | Re: Slow connection to the database |
| Previous Message | Tony Caduto | 2005-09-24 18:13:35 | Re: Extraordinarily slow!! |