Re: hyper slow after upgrade to 8.1.4 - Mailing list pgsql-performance

From Medora Schauer
Subject Re: hyper slow after upgrade to 8.1.4
Date
Msg-id 1CA058827877644DAB54FB930FFA3B05A67C31@lincoln.FAIRIND.FAIRFIELD.COM
Whole thread Raw
In response to hyper slow after upgrade to 8.1.4  ("Medora Schauer" <mschauer@fairfield.com>)
List pgsql-performance
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Thursday, July 13, 2006 11:12 AM
>
> Michael Fuhr <mike@fuhr.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



pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: size of pg_dump files containing bytea values
Next
From: Tom Lane
Date:
Subject: Re: Problem with bitmap-index-scan plan