Re: hyper slow after upgrade to 8.1.4

> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Thursday, July 13, 2006 11:12 AM
>
> Michael Fuhr <mike(at)fuhr(dot)org> writes:
> > On Thu, Jul 13, 2006 at 08:22:46AM -0500, Medora Schauer wrote:
> >> Can it be that the connection delay is because first an IPv6 socket
is
> >> trying to be established and when that fails an IPv4 socket is
created?
>
> > A sniffer like tcpdump or ethereal might reveal why connecting is
> > so slow.
>
> I'd try strace'ing the client process first --- whatever is slow might
> not be exposed as TCP traffic. It does sound though that the problem
> is related to userland expecting IPv6 support that the kernel doesn't
> actually have.
>
> regards, tom lane

Good idea Tom. Strace showed communications with a machine that didn't
make sense. Turns out someone had configured DNS on the "slow" machine
but the DNS server wasn't running. When I use the IP address of the PG
server rather than the name with psql, the connection is made quickly.

Thanks for all the help everyone,

Medora Schauer