Skip site navigation (1) Skip section navigation (2)

Re: hyper slow after upgrade to 8.1.4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Medora Schauer <mschauer(at)fairfield(dot)com>, Bruno Wolff III <bruno(at)wolff(dot)to>, postgresql <pgsql-performance(at)postgresql(dot)org>
Subject: Re: hyper slow after upgrade to 8.1.4
Date: 2006-07-13 17:11:56
Message-ID: 16044.1152810716@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2006-07-13 17:42:41
Subject: Re: size of pg_dump files containing bytea values
Previous:From: Greg StarkDate: 2006-07-13 16:30:50
Subject: Re: size of pg_dump files containing bytea values

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group