Re: hyper slow after upgrade to 8.1.4

> From: Bruno Wolff III [mailto:bruno(at)wolff(dot)to]
> Sent: Wednesday, July 12, 2006 8:54 PM
> To: Medora Schauer
> Cc: postgresql
> Subject: Re: hyper slow after upgrade to 8.1.4
>
> On Wed, Jul 12, 2006 at 15:41:14 -0500,
> Medora Schauer <mschauer(at)fairfield(dot)com> wrote:
> > I have just upgraded from 7.3.4 to 8.1.4 and now *all* db access
calls
> > are extremely slow. I didn't need to preserve any old data so at
this
> > point all my tables are empty. Just connecting to a db takes
several
> > seconds.
> >
> > I know I'm not giving much to go on but I'm stumped. Can anyone
suggest
> > how I might track down the cause of this problem?
>
> That connections are slow makes me think DNS is worth looking at. It
might
> be that reverse lookups are timing out.

It does seem to be network related. Using the 8.1.4 psql on a machine
other than the db server connecting to a database takes ~11 secs. Using
it on the db server the connection is virtually instantaneous. Using
the 7.3.4 psql (still the 8.1.4 postmaster) the connection is fast
regardless of what machine I am on.

The pg.log contains the following at the top:

LOG: could not create IPv6 socket: Address family not supported by
protocol

I am using a 2.4.25 linux kernel. For reasons I can't get into I have
no choice but to use this kernel. The config utility for the kernel
shows support for the IPv6 protocol as "experimental" and is not
included in my current build. I can try building a kernel that includes
IPv6 but the "experimental" caveat is scary.

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?
If so, is there any way to make 8.1.4 use only IPv4 sockets?

BTW - The slowness seems to be only during db connection. Once the
connection is established queries seem to execute in a timely manner.

Medora