Re: hyper slow after upgrade to 8.1.4

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

 



> From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx]
> Sent: Thursday, July 13, 2006 11:12 AM
> 
> Michael Fuhr <mike@xxxxxxxx> 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




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

  Powered by Linux